Complete information-level design for set of requirements

Assignment Help Database Management System

Reference no: EM1360003

1. A database at a college is required to support the following requirements. Complete the information-level design for this set of requirements. Use your own experience to determine any constraints you need that are not stated in the problem. Represent the answer in DBDL.

a. For a department, store its number and name.

b. For an advisor, store his or her number and name and the number of the department to which he or she is assigned.

c. For a course, store its code and description.

d. For a student, store his or her number and name. For each course the student has taken, store the course code, course description, and grade received. In addition, store the number and name of the student's advisor. Assume course description, and grade received. In addition, store the number and name of the student's advisor. Assume that an advisor may advise any number of students but that each student has just one advisor.

Reference no: EM1360003

Questions Cloud

Ways of implementing one-to-one relationships : Describe the difference ways of implementing one-to-one relationships. Assume you are maintaining information on offices (office numbers, building, and phone numbers)

Why should john and karl live together : Why should John and Karl live together. If they do, will there be dirty dishes in the sink. Explain

What is drucker saying with this quote : What is Drucker saying with this quote and Do you agree or disagree? Does business really have other societal obligations besides making a profit?

How weight represents the amount of raw materials : How weight represents the amount of raw materials. Data containing the weight in pounds from a sample of 368 pallets of Bridgetown shingles and 330 pallets of Holetown shingles are contained in Pallet data which can be downloaded from the class web..

Complete information-level design for set of requirements : A database at a college is required to support the following requirements. Complete the information-level design for this set of requirements. Determine any constraints you need that are not stated in the problem.

Vertical and horizontal integration in organizations : Vertical and Horizontal Integration in Health Care Organizations - beginning of the new century the pace of integration slowed. Why have vertical and horizontal integration become less popular for health care organizations?

Determine the different types of financial reports : Determine the different types of financial reports you communicate with in accounting, and what do they tell you?

Concepts based on freudian theory : There are a number of concepts that are based in Freudian theory that many do not realize stem from him. Identify a few ideals and terms that can be traced back to Freud.

Show fixed price policy : Why do you think Standard Machine is in this difficult situation with what was previously a loyal customer? What has changed? What would you do?

User Account

All Pages