Scribd
Upload
113 views

EER Exercises

The document describes two exercises for designing databases: 1. For a university registrar's office to track courses, course offerings, students, instructors, and student enrollments and grades. This involves identifying entities, relationships, and drawing an ERD with mapping constraints. 2. For the U.S. House of Representatives to track states, representatives, bills, votes, and the relationships between them. This involves designing an ERD and stating assumptions and business rules.

Uploaded by

Hager khaled kh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
113 views

EER Exercises

The document describes two exercises for designing databases: 1. For a university registrar's office to track courses, course offerings, students, instructors, and student enrollments and grades. This involves identifying entities, relationships, and drawing an ERD with mapping constraints. 2. For the U.S. House of Representatives to track states, representatives, bills, votes, and the relationships between them. This involves designing an ERD and stating assumptions and business rules.

Uploaded by

Hager khaled kh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Information System Department

Database Systems
Exercises

1. What is the difference between logical independence and


physical data independence?

2. A Company has several departments. Each department has a


supervisor and at least one employee. Employee must be
assigned to at least one, but possibly more department. At least
one employee is assigned to a project, but an employee may be
on vacation and not assigned to any projects. A database should
provide following details to the user
i. Identify all entities
ii. Identify all relations.
iii. Draw E-R Diagram

Document all assumptions that you make about the mapping


constraints.
Information System Department
Database Systems
Exercises

1. A university registrar’s office maintains data about the following


courses, including number, title, credits, syllabus, and
prerequisites; course offerings, including course number, year,
semester, section number, instructor(s), timings, and classroom;
students, including student-id, name, and program; and instructors,
including identification number, name, department, and title.
Further, the enrollment of students in courses and grades awarded
to students in each course they are enrolled for must be
appropriately modeled.
A database should provide following details to the user
iv. Identify all entities
v. Identify all relations.
vi. Draw E-R Diagram
Document all assumptions that you make about the mapping
constraints.

2. Explain the difference between a weak and a strong entity set


1. List various users of DBMS and specify the roles?

2. You have just moved to Washington, D.C., to work for the U.S. House of
Representatives (the “House”) as a database specialist. For your first
job, they want you to design a database to keep track of votes taken in
the House. (A counterpart to you working for the U.S. Senate is
designing a similar database for tracking votes in the Senate.) The
database will track votes taken in the House during the current two-
year congressional session. It should record each U.S. state (for
instance, Texas) with its name, number of representatives, and region in
which the state is located (northeast, mid-atlantic, midwest, and so
forth). Each congress-creature, er, I mean representative, in the House
is to be described by his or her name, the district (by district number)
that he or she represents, the year when he or she was first elected,
and the political party to which he or she belongs (for instance,
Republican, Democrat, Independent, Green, Reform, Other). The
database should track each bill (legislation) with its name, the date on
which its vote was taken, whether the bill passed or failed (so the
domain is yes and no), and its sponsors (the representatives who
proposed the bill). The database should track how each representative
voted on each bill (yes, no, abstain, absent). a. Design an entity-
relationship (E-R) schema diagram for the above enterprise. Be careful
to ensure that each of the attributes would be restricted to legal
values (no pun. . .). State clearly any assumptions that you make. Also
state any business rules—logic to which the database should adhere—
that are not captured in your E-R diagram.
The Bill entity box represents the collection of all bills that come to
the floor of the house. A representative votes on each bill, so he or she
votes on many bills. And, of course, each bill is voted on by many
representatives. So the rel-ship votes is properly many-
many.

You might also like