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

Assignment Help:

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.


Related Discussions:- Draw enhanced er-diagram for hierarchy of a student database

Create table and insert data manufacturer-dbms, Create a table according to...

Create a table according to given data:  AmbulanceDriver(Driver_Number#, Name, Address, Birth_Date) AmbulanceDriverTeam(Team_Number#, Driver_Number#, Join_Date, Lea

Information infrasture, what benefit can a company gain by managing its own...

what benefit can a company gain by managing its own infrasture and services

Introduction to Database Design and Development, Every School has many teac...

Every School has many teachers and many students. Each student is assigned to one school and each teacher works for one school only. Each teacher teaches more than one subject but

What are the different kinds of database end users, What are the different ...

What are the different kinds of database end users? Discuss the major activities of each? End-Users - End-users are the people whose jobs need access to the database for que

Create a new service-based database, In this assignment, you will create a ...

In this assignment, you will create a program that works with multiple tables. In this assignment, you will work with the factory and sales tables. 1. Create a new project nam

BI, (a) Why did SAP introduce the extended star schema?

(a) Why did SAP introduce the extended star schema?

Database project- inventory database for a hardware store, Normal 0 ...

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Incident report to the database, The Form input elements are:           ...

The Form input elements are:             Reporter name                                                text type input             Password

Define the concept of generalization, Define the concept of generalization ...

Define the concept of generalization A generalization is relationship between specific kind of thing and general thing. It is also known as "is-a-kind-of" relationship. Inher

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd