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
Which operations need the participating relations to be union compatible? A UNION, INTERSECTION and DIFFERENCE operations need the participating relations to be union compatibl

Process of normalization is the integral part of designing a database. Justify this statement with suitable database design

Backward Recovery (UNDO): In this system the uncommitted changes made by a transaction to a database are undone.  Instead the system is reset to the last consistent state of databa

What are composite objects? Objects that have other objects are known as complex objects or composite objects.

A Distributed Transaction Let us demonstrate the concept of a distributed transaction by considering a banking system having of three branches located in 3 different cities. Ev

Synonyms It allows short names or alternative names for objects. Example :               CREATE SYNONYM D30               FOR EMPD30;   Now if we give command:

Describe the objective of Structural Diagrams The main objective of structural diagram is to visualize, construct, specify and document static aspects of a system. Their eleme

The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

(a) Explain briefly the three parts of a relational Model. (b) Contrast the following terms with an appropriate example: (i) stored attribute v/s derived attribute (ii) en

What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is