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

Ask an Expert

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

Write your message here..

Related Questions

Clustering indexes, Clustering Indexes It may be an excellent idea to k... Clustering Indexes It may be an excellent idea to keep data of the students in the order of the programme they have registered as most of the data file accesses may need studen

Give some encryption techniques, Give some encryption techniques? A)  D... Give some encryption techniques? A)  DES  B) AES  C) Public key encryption

Objectives of data management, The traffic data mgmt. systems infrastructur... The traffic data mgmt. systems infrastructure plan describes the software, hardware, data network, and other elements that will support the TDMS. The infrastructure plan is based o

Online Bakery Data Base Project, How much would you charge to create a data... How much would you charge to create a database encompassing an Online Bakery with all the elements below? I. Describe the application that you would like to design. This should

Describe the benefits of OOD techniques, Describe the benefits of OOD techn... Describe the benefits of OOD techniques OOD techniques are very useful for development of large and complex systems. It has been noted that large projects that are developed u

Explain the isa relationship, Explain the ISA relationship Answer: IS... Explain the ISA relationship Answer: ISA relationship - ISA notation is employed in generalization/ specialization to depict relationship among lower and higer level entity s

What is a dataset, What is a dataset? A dataset is an in-memory databas... What is a dataset? A dataset is an in-memory database that is disconnected from any regular database, but has all the significant characteristics of a regular database. Dataset

What is the initial step for object-oriented designing, What is the initial... What is the initial step for object-oriented designing The initial step for object-oriented designing is object modeling. Before we go into deep about object modeling first of

Computer, 1. Will you advise that your organization uses open source softwa... 1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

Explain the terms data warehousing and data mining, Question: i) Explai... Question: i) Explain the terms data warehousing and data mining. ii) Discuss the importance of the following security principles that a digital firm should amongst others, n