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 Asterisk in SQL? Asterisk (*): In SQL, the columns for all the tables and views in the FROM clause will be displayed.

What are the two types of blocks in the fixed -length representation? Define them. Anchor block: Have the first record of a chain. Overflow block: Have the records other tha

Why a report generator is used ? Report generator is used for print files on paper.

Spanned and unspanned organisation? Spanned and unspanned organization: If records are not permited to cross block boundaries then the organisation is called unspanned record

List the requirements needed to design a trigger. The requirements are:- Specifying when a trigger is to be implemented. State the actions to be taken when the trigger im

Describe relational model? Structure of relational data base Basic structure Database schema Keys Schema diagram Query languages

Question: (a) e-Government implementations normally evolve through a multi-stage process. Describe, using appropriate examples, the stages involved in an e-Government implemen

What is equi join? Equi Join - It generates all the combinations of tuples from two relations which satisfy a join condition along with only equality comparison (=).

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

Explain the θ-join and equijoin Refer tables Car and Boat which list models of cars and boats and their relevant prices. Assume a customer wants to buy a car and a boat, but sh