Information-level design for college requirements

Reference no: EM1372272

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 (for example MTH110 or Algebra).

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: EM1372272

Questions Cloud

Why they violate human right to water. : People should control water, not corporations. Water is a common resource and we all have an equal right to this precious resource and a responsibility to protect it. Pre-Paid Water Meters: Why they violate human right to water.

How long would it take to fill the tank : A force does +130J of work while it acts on a moving object and its direction is in the same direction as the object's displacement. How much work does this force do as the angle between it and the object's displacement is 56°.

How much work is finished by gravity : The acoustical system is driven by speaker emitting a 432Hz note. If destructive interference occurs at a particular instant, by what least amount amount must the difference of two path lengths in the U-shaped tube be increased so as to hear const..

Explain firm output and labour employed in short run : Production When you have completed your study of this chapter, you will be able to 1 2 3 4 Explain how economists measure a firms cost of production and profit. Explain relationship between a firm output and labour employed in short run.

Information-level design for college requirements : Database at college is needed to support following requirements. Complete information-level design for this set of requirements. Use your own experience to find out any constraints you require which are not stated in problem

Find the direction of the chickens acceleration : The infamous chicken is dashing toward home plate with a speed of 5.70 m/s when he decides to hit the dirt. The chicken slides for 1 s, just reaching plate as he stops (safe, of course).

Explain the relationships between atc and mtc : Economists estimated the following cost function for X Company, Compute the ATC, AVC and MTC and plot on another graph.

What was originally given to employees : Now looking at this scenario, would company rather increase wages slightly, not so much that it will decrease profits, but to a point where productivity may rise higher than what was originally given to employees.

Calculating conversion costs : The Rainbow Paint Company uses a process costing system. Materials are added at the starting of process and conversion costs are incurred uniformly.

User Account

All Pages