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
how to construct labelled precedence graph for view serialiability.please explain insteps with one solved examples

how to submit answers softcopy

Describe Database state in details? Database state: The actual data within the database at a particular moment in time is known as a database state.

Why is database redesign necessary? Database redesign is essential for two reasons. First, redesign is essential both to fix mistakes made during the initial database design. S

Explain Deadlock detection and recovery Deadlock Detection - A deadlock is said to take place when there is a circular chain of transaction, every waiting for the release of a


What are the three types of data sources used with ODBC? An ODBC file data source is a file that can be shared between database users. An ODBC system data source is one that is

Discuss the methods for a hash file to expand and shrink dynamically. What are the advantages and disadvantages of each? The hashing methods that permit dyanamic file expansi

Performance of Various Concurrency Control Mechanisms

Whta is the advantage of the database management approach? The advantage of the database management approach is data is integrated and can be accessed by multiple programs.