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

Non-query optimisations, Part: Recommended (Non-query) Optimisations Thi...

Part: Recommended (Non-query) Optimisations This section entitled "Recommended (non-query) optimisations" should be a brief report containing recommended optimisations you would

Create a new user-data control, Create a new user : CREATE USER IDENTI...

Create a new user : CREATE USER IDENTIFIED BY Example: //CREATE USER MCA12 IDENTIFIED BY W123 Grant: It is used to give database access permission to users. It is of

Define union compatibility, Define union compatibility? Explain why INTERSE...

Define union compatibility? Explain why INTERSECTION of two relations cannot be performed if they are not union compatible? Two relations R(A1, A2,-------, An) and S(B1, B2,--

Case snerio, each publisher has uniqe name a mial addrs are also kept on ea...

each publisher has uniqe name a mial addrs are also kept on each pubisher.a publisher publish one book.a book publish y one publisher.book identified by isbn.each book writn by one

What is functional dependency, A Functional dependency is described by ...

A Functional dependency is described by X Y between two groups of attributes Y and X that are subsets of R specifies a constraint on the possible tuple that can make a relation

Get details of employee working on both comp354 and comp345, Consider the r...

Consider the relations EMPLOYEE(emp#, name) ASSIGNED_TO(project#, emp#) PROJECT(project#, project_name, chief) Express the subsequent queries in Relational Algebra (i) Ge

What is an index, What is an index? An index is a structure that helps ...

What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

The result of the union operation between r1 and r2, The result of the UNIO...

The result of the UNION operation between R1 and R2 is a relation that includes? The result of the operation between R1 and R2 includes all the tuples of R1 and R2 which have c

Explain consistency model , Explain in detail the consistency model of the ...

Explain in detail the consistency model of the distributed file system you studied (GFS or AFS). Present the consistency model chosen and how it was achieved through design. Clarit

Explain the exists and unique functions of sql, Explain the EXISTS and UNIQ...

Explain the EXISTS and UNIQUE functions of SQL. Give an example for each? EXISTS: The EXISTS function takes one parameter that is a SQL statement. If any records exist which

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