Database Design Using MySQL: Assignment

Added on -2019-09-20

| 3 pages
| 878 words
| 565 views

Trusted by 2+ million users,
1000+ happy students everyday

Showing pages 1 to 1 of 3 pages

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

Found this document preview useful?

You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss

Students who viewed this