1 / 20

Database Design and Creation Using MySQL

Database Design and Creation Using MySQL. Track 3 : Basic Course in Database. Learning Objectives:. At the end of the session, you should be able to: Model a database Understand (Relational Database Management System) RDBMS concept Appreciate MySQL as an open-source RDBMS. Database Design.

manjit
Download Presentation

Database Design and Creation Using MySQL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Design and Creation Using MySQL Track 3 : Basic Course in Database

  2. Learning Objectives: At the end of the session, you should be able to: • Model a database • Understand (Relational Database Management System) RDBMS concept • Appreciate MySQL as an open-source RDBMS

  3. Database Design Entity-Relationship Diagram (ERD) is a tool for modeling data. 3 concepts to remember about ERD • Entity - the main object in the problem domain. • Attribute - describes the main object (entity). • Relation - association defines the between entity.

  4. How to maintain an inventory of contact individuals and institutions? Database Case Study Mayang: I have a problem in my Resource Center Wilma: I suggest you use a DBMS to help you manage your data...

  5. Steps to Create ERD • Identify the entity • Identify the entity's attributes • Identify the relation between entities

  6. Steps to Create ERD • Identify the entity

  7. Steps to Create ERD • Identify the entity's attributes • 1st Form

  8. Steps to Create ERD • Identify the entity's attributes • 2nd Form

  9. Steps to Create ERD • Identify the relation between entities

  10. Additional DBMS Concepts • Relational DBMS (RDBMS • Commercial RDBMS (expensive) • Oracle, Informix, SQL Server • GNU General Public License software (free) • MySQL, mSQL or PostGres.

  11. MySQL • A Relational Database Management System (RDBMS) that is multi-user • Say it as ``My Ess Que Ell". several computer workstations can access and write into a single database

  12. Where to get MySQL • Stable version at this time is MySQL version 3.22.x. • Asia: • China [Freecode] http://mysql.freecode.com.cn • China [Netfirm] http://mysql.netfirm.net • Korea [KREONet] http://linux.kreonet.re.kr/mysql/ • Japan [Soft Agency] http://www.softagency.co.jp/MySQL

  13. Where to get MySQL • Stable version at this time is MySQL version 3.22.x. • Asia: • Japan [Nagoya Syouka University] http://mirror.nucba.ac.jp/mirror/mysql or ftp://mirror.nucba.ac.jp/mirror/mysql • Singapore [HJC] http://mysql.hjc.edu.sg or ftp://ftp.hjc.edu.sg/mysql • Taiwan [HT] http://mysql.ht.net.tw

  14. Where to get MySQL • Stable version at this time is MySQL version 3.22.x. • Australia: • Australia [AARNet/Queensland] http://mirror.aarnet.edu.au/mysql or ftp://mirror.aarnet.edu.au/pub/mysql • Australia [Blue Planet/Melbourne] http://mysql.bluep.com/ • Australia [ITworks Consulting/Victoria] http://mysql.itworks.com.au

  15. MySQL Datatypes • INT • can contain values up to 2147483648 • INT • INT(3) • REAL • can contain values from-3.402823466E+38 to -1.175494351E-38, 0 and 1.175494351E-38 to 3.402823466E+38

  16. MySQL Datatypes • DECIMAL[(M[,D])] • DECIMAL(5,2) • CHAR(length) • fixed character length, wastes diskspace • CHAR(10) • VARCHAR(length) • variable character length, economical to use • VARCHAR(10)

  17. MySQL Datatypes • DATE • Y2K Compliant • displays DATE values in 'YYYY-MM-DD' format • TIME • displays TIME values in 'HH:MM:SS' format • DATETIME • displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format

  18. Recommended MySQL datatypes • INT • DECIMAL (M,D) • VARCHAR(length) • DATE

  19. DATA DICTIONARY

More Related