scenario, stating any assumptions you find it necessary to make, and showing unknown cardinalities and optionalities using question marks on the relationship line.Show also the attributes explicitly mentioned in the scenario and underline any you consider suitable candidates for being primary keys.
[email protected] 2019It is required to keep the following information on students, courses and subcourses. Each student has a name, identification number, home address, term address, and a number of qualifications for which the subject (e.g. maths), grade (e.g. C) and level (e.g. `A' level) are recorded. Each student is registered for one course where each course has a name (e.g. Information Systems) and anidentification number. Record is kept of the number of students registered for each course.Each course is divided into subcourses where a subcourse may be part of more than one course. Information on subcourses includes the name, identification number and the number of students taking the course.Exercise 4 - MORTGAGESDraw an entity-relationship diagram for the following. Produce also a list of questions you wouldhave to have answered in order to complete the model. In a case study of this kind, and in particular in exam questions, there is not usually the space to completelyspecify a problem. Remember also that not all the information given in a case study of this type is necessarily relevant. Some information, while relevant to the organization concerned, might not be relevant as far as database design is concerned.
You've reached the end of your free preview.
Want to read all 3 pages?
- Summer '15
- Entity-relationship model, entity