Draw enhanced er-diagram for hierarchy of a student database, Database Management System

Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name) and "additional" information about undergraduate students. A student may enrol in the BCSc degree program, the co-op program, or both (e.g., a BCSc student is-a student). For the BCSc student, the database records the year in which he is in (e.g., Year3, Year4) as "additional" information. Each co-op student can further be categorized into Canadian or international students. For the former, the database records his SIN; for the latter, the database records his work permit information (passport number and its issuing country, as well as the work permit number). Hint: Make sure you clearly identify the (disjoint vs. overlapping, total vs. partial) constraints.

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







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

Write discussion on Draw enhanced er-diagram for hierarchy of a student database
Your posts are moderated
Related Questions
What is called query processing? Query processing refers to the range of activities included in extracting data from a database.

Differentiate OO development from structured development. Structured approach of problem solving is based upon the idea of decomposition of system into subsystem. In this appro

What are the costs to be considered when a transaction has to be rolled back when recovering from deadlock?         Ans: A few transaction will must rolled back (made a victim)

What is a Transaction? A transaction is an event which happens on the database. Generally a transaction reads a value from the database or writes a value to the database. If y

What is object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.

Define average latency time. The average latency time of the disk is one-half the time for a full rotation of the disk.

What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data


difference between internal schema and external schema in DBMS

Funky Festivals Specification Funky Festivals organise music festivals which take place at various venues throughout the UK.  A venue needs to be booked before a Festival can t