Draw an er diagram for organization of a student database, Database Management System

Draw an ER diagram that shows the organization of a simple student database. The database captures the information about letter grades obtained by university students who enrolled in some sections of courses taught by some professors. In the database, each student is represented by a student ID and student name. Each course is represented by a course ID, a course name, and the number of credits assigned to the course; each section of a course is represented by a section ID (e.g., section "A01" of the 3-credit course "COMP 3380" named "Database concepts and usage").

Each professor is represented by the ID, name, office number and email address of the professor. Here, we assume that

(a) a student cannot repeat any courses,

(b) a student may take different sections of a course (e.g., COMP 4060 A03 and A08), and

(c) each course section is taught by one professor. Hint: Make sure you clearly identify the primary key of each entity set, the mapping cardinality of each relationship set, and also explicitly state the primary key of each relationship set.

Posted Date: 2/28/2013 6:19:27 AM | Location : United States







Related Discussions:- Draw an er diagram for organization of a student database, Assignment Help, Ask Question on Draw an er diagram for organization of a student database, Get Answer, Expert's Help, Draw an er diagram for organization of a student database Discussions

Write discussion on Draw an er diagram for organization of a student database
Your posts are moderated
Related Questions
What is Oracle Process? Explain any four processes started by Oracle. Oracle Process is as follows: SMON: The System Monitor carries out a crash recovery while a crashed in

Illustrate different types of Locks in SQL Server. There are three kinds of locks in SQL Server i.) Shared locks - These are used for operations which don't allow any update

Unrepeatable reads : Assume T7 reads X twice during its implementation. If it did not update X itself it could be very disturbing to see a dissimilar value of X in its next read. B

Domain Constraint It shows that each attribute in a relation has to contain an atomic value only from the corresponding domains. The data types associated with commercial RDBMS

Explain the differences between structured data and unstructured data. Structured data are facts concerning objects and events. The most significant structured data are numeric

Consider the following relational scheme: R (a,b,c,d,e,f) and its corresponding set of FDs {d→ a, be → c, ac → e, b → f, f → d, a → c}. a. Is the following decomposition i) non

The Structured Query Language INTRODUCTION Database is an organised set of information about an entity having controlled redundancy and serves numerous applications. DBMS

We have a buildup of payments that need to be processed. You will need:- To prepare customer account on our site Process payment (you must have working Paypal account to d

Question: (a) Discuss the difference between a composite key and a composite attribute. How would each be indicated in an E-R diagram? Support your answer with appropriate exam

A Data Model in software engineering is an abstract model that organizes and documents the business data for interaction between team members and is used as a plan for creating