logo

Database Design Using MySQL: Assignment

3 Pages878 Words565 Views
   

Added on  2019-09-20

Database Design Using MySQL: Assignment

   Added on 2019-09-20

ShareRelated Documents
Instructions: You need to create a database design using MySQL Workbench EER Modelling tool. ERD tutorial instructions are provided in the course informationThe ERD should have appropriate Entities, Relationships, Foreign Keys and Primary KeysThe Attributes should have appropriate DataTypesSave the model as a .mwb file with your name in the filename. Use the data items below in your model. Data Items (Attributes)The data items below are (somewhat) self-describing. However, one or two are not as straight forward as they might seem. It is best if you develop a data name which is descriptive, but not to long. The list below excludes Primary Keys because it would make the Entities too easy to define. Create appropriate Primary keys where appropriate (ie Student ID) However, Result ID is not an acceptable PK. (Excluding the Primary Keys for your entities) Student first nameStudent last nameContact phone number for studentStudent emailStudent nationalityStudent birth dateStudent gender (M/F)Student date of enrolment ( commencement date at the school)Student date of enrolment (in a specific subject)Student grade (Pass Fail etc. ) Student result (0-100)Date resultedSchool nameSchool addressSchool phoneSchool emailTeacher nameTeacher phoneTeacher email Subject nameSubject descriptionSubject coordinatorCost of the subject Duration of the subject (in hours)Quantity of assessment items for the subjectCreate appropriate primary keys & foreign keys where necessary Ie Student ID, School ID are OK, however Result ID is not acceptable
Database Design Using MySQL: Assignment_1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
ER Diagram, Relational Data Logical Model, Data Dictionary
|6
|563
|75

NIT1201 Database Management System Assignment (DBMS)
|20
|2180
|351

Entity Relationship Diagram in Library Management System
|25
|2195
|76

BIT103/DIP203 Assignment Introduction to Structured Programming
|6
|1673
|358

SQL Final Exam
|3
|777
|265

ICT40115 - Certificate IV in Information Technology
|10
|741
|216