Prepare an erd for the scenario, Database Management System

Assignment Help:

Question:

(a) Prepare an ERD for the scenario given below.

(b) Convert the ER diagram produced in (a) above into its physical design. You have to choose an appropriate Primary Key for each table identified in the scenario and underline it to differentiate it with other non key attributes. You also have to show any identified Foreign Key in the physical designed.

The Department of Computing and Mathematical Sciences of Imperial College has a set of courses provided for the undergraduate level. For each course a well defined set of admission criteria is specified; for instance, for the "Computer Science" course, 3 A-levels are required, minimum B for each, an A level in Mathematics being compulsory. Each course has a name, Type and duration. Each course consists of a set of modules, some compulsory and some optional. A certain module is described by its name, a short syllabus, type (lectured, seminar-like, project) and year (Level) of study for which it was intended. Each student enrolled with the department, is registered for one particular course. The student must attend the compulsory modules. The system must also store the grade obtained by each student for each module taken. For every year of study, from the set of optional modules, the student must attend a certain number which is specified in the course's description. Each module is taught by a single lecturer. However, there might be modules, from the optional ones, that are not taught at all (for instance, because no students have actually registered for them). There also can exist lecturers who do not teach at all, being only involved in research. Contact information (address, telephone, ...) plus personal details (date of birth, male/female, ...) is needed for both lecturers and students.


Related Discussions:- Prepare an erd for the scenario

Normalization, Process of normalization is the integral part of designing a...

Process of normalization is the integral part of designing a database. Justify this statement with suitable database design

Tuples-attributes , Consider a relation s over the attributes A and B wit...

Consider a relation s over the attributes A and B with the following characteristics: 5,000 tuples with 10 tuples per page A 2-level B+ tree index on attribute

Clustering indexes, Clustering Indexes It may be an excellent idea to k...

Clustering Indexes It may be an excellent idea to keep data of the students in the order of the programme they have registered as most of the data file accesses may need studen

What is the purpose of storage manager, What is the purpose of storage mana...

What is the purpose of storage manager? The storage manager is responsible for the following a) Interaction with the file manager b) Translation of DML commands in to low

Database models, why are older data models are being replaced by new data m...

why are older data models are being replaced by new data models

Insertion anomaly-data redundancy, Insertion Anomaly: Inability to show ce...

Insertion Anomaly: Inability to show certain information-The primary key of the over relation be (enrolment number, Cno). Any new tuple to be inserted in the relation should have

Define the terms ddl and dml, Define the terms i) DDL ii) DML DDL: Data...

Define the terms i) DDL ii) DML DDL: Data base schema is particular by a set of definitions expressed by a special language known as a data definition language. DML: A data

What is a cascading update, What is a cascading update? Referential int...

What is a cascading update? Referential integrity constraints needs that foreign key values in one table correspond to primary key values in another. If the value of the primar

Compare wait-die deadlock prevention with wait-wound scheme, Compare wait-d...

Compare wait-die deadlock prevention scheme with wait-wound scheme   Ans:  Wait-Die Scheme  a) Based upon a nonpreemptive technique.  b) If Pi requests a resource present

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd