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 a B+-Tree index? A B+-Tree index takes the form of a balanced tree in which each path from the root of the root of the root of the tree to a leaf of the tree is of the

This language that enable user manipulate to or access data as organized by appropriate data model. Low level or Procedural DML : DML needs a user to specify what data ar

Discuss the mechanism to read data from and write to a disk? Disk read/write heads are mechanisms in which read data from or write data to disk drives. The heads have gone by

Multiple column Queries: Syntax: SELECT COLUMN1, COL2,...... FROM TABLE WHERE (COLUMN1, COL2, ...) IN (SELECT COLUMN1, COL2,....  FROM TABLE WHERE );

What is System R? What are its two major subsystems? System R was intended and developed over a period of 1974-79 at IBM San Jose Research Center. It is a prototype and its pur

Express the properties of Strings? Strings can be case sensitive (or not) which can change the outcome of string operations. You can evaluate whole strings \ just part

Redo Logs: Any database must have minimum two redo logs. These are the rules for the database; the redo logs record all modifies to the system objects or user objects. If any type

Question 1 Explain ER model Question 2 What are the characteristics of a computer provided information? Question 3 What are facts and guidelines to be considered when se

Explain Interblock gap? Interblock Gap - A track of a disk is separated into equal-sized disk blocks. Blocks are separated through fixed-size gaps, called as interblock gaps th

Hashed File Organisation Hashing is the most common form of purely random access to a database or file. It is also used to access columns that do not have an index as an optimi