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
i want answers this assignment now if yiu can maket for me now ?

Describe integrity and security? a)      Domain constraint b)      Referential integrity A value that appears in one relation for a given set of attributes also appear fo

Preliminary entities and attributes of human resourse management database management system

OPENCART - Want Massive amount of products Imported through CSV We have a massive list of products that would take completely too long to do data entry. We require a slick progr

What are attributes? Give examples. An entity is shown by a set of attributes. Attributes are descriptive properties possessed by every member of an entity set. Example: pos

A relation instance indicates as r is a collection of tuples for a given relational schema at a exact point of time. A relation state r of the relation schema R (A 1 ,A 2 ,.....


Log based recovery: Let us first describe the term transaction log in the context of DBMS. A transaction log is a record in DBMS that remains track of all the transactions of a dat

Differentiate between logical database design and physical database design. Show how this separation leads to data independence? Basis Logical Databas