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

Database errors, Database Errors: An error is said to have occurred if the ...

Database Errors: An error is said to have occurred if the implementation of a command to manipulate the database cannot be successfully finished either due to inconsistent data or

Is siteground database over limit, I am using Siteground. And my databas...

I am using Siteground. And my database is full of limit so need someone who reduces the data which no need. This is very simple and simple task. Skills required are Databa

Eliminate repeating groups, Eliminate Repeating Groups The problem is, ...

Eliminate Repeating Groups The problem is, "Find out the list of employees, who knows DB2". For this problem we require to perform an awkward scan of the list looking for re

What is business intelligence, Question A What is operational intelligence...

Question A What is operational intelligence? Question B What is Business Intelligence? Explain the components of BI architecture Question C Differentiate between databas

Hashing techniques, folding method and mid square method using visual basic...

folding method and mid square method using visual basic

Describe the advantage of state chart diagram, Describe the advantage of St...

Describe the advantage of State chart Diagram A state chart represents a state machine, emphasizing flow of control from one state to other. A state machine is a behaviour whi

Normalization, Introduction In large projects, we can have many different ...

Introduction In large projects, we can have many different companies working together. Generally, the project or contract is awarded to one company (Principal Contractor), which

Write the motivations led to development of oo-dbms, Write the motivations ...

Write the motivations led to development of OO-DBMS? 1.  Programmer frustration with RDBMSs. 2.  Requirement for special features.

Which sorting technique is used to sort databases, Which sorting technique ...

Which sorting technique is used to sort databases, whose sizes are very big?  Give one such algorithm.  Why do sorting techniques like quicksort, insertion sort, etc.  not applied

Design of a database, Ask questioYou are the database administrator in a un...

Ask questioYou are the database administrator in a university. You have been tasked to come up with a new database for the University. Using the stages in Database Life Cycle come

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