Computers and Technology, 21.05.2020 11:58 fermaluis8015

Suppose that you have the following requirements for a university database that is used to keep
track of students’ transcripts: The university keeps track of the students name, student number,
current address, phone, birth date, gender, class (‘freshman’, ‘sophomore’, … , ‘graduate’),
major department. Each department is described by a name, department code, office number
and college. Each student can study more than a course that has a course name, description,
course code, number of semester hours, level, and offering department. Finally, a grade record
refers to a student, a particular course, and the total degree of all courses he has studied.
Design the ERD for this database and implement the schema for this database application using
the suitable SQL commands. First show all the functional dependencies that should hold among
the database attributes. Then design relation schemas for the database that are each in 3NF with
clarifying the conditions you have applied to reach the 3NF. Specify the key attributes of each
relation. Note make any appropriate assumptions to render the specification complete.

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 08:00

What best describes a career pathway in a lodging career? a worker starts out as an amusement attendant, then becomes a recreation worker, and then becomes a gaming worker within five years. a worker starts out as a bell hop, then becomes a night clerk, and then becomes a hotel manager within five years. a worker starting out as a tour guide, then becomes a travel clerk, and then becomes a travel agent within five years. a worker starts out as a server, then becomes a food preparer, and then becomes a head chef within five years.

Answers: 1

Answer

Computers and Technology, 23.06.2019 04:20

4. a1. vince owns a television repair shop that is insured undera commercial package policy. the policy includes thebuilding and personal property coverage form and thecauses-of-loss broad form. the declarations page indicatesthat coverage applies to both the building and the namedinsured's business property. explain whether or not thefollowing losses would be covered under his policy.a. a fire occurs on the premises, and the building isbadly damaged.b. a burglar steals some money and securities from anunlocked safe.c. a business computer is damaged by vandals whobreak into the shop after business hours.d. a tornado touches down near the store. several tel-evision sets of customers in the shop for repair aredamaged in the storm.til

Answers: 2

Answer

Computers and Technology, 23.06.2019 06:30

You have a small company and want to keep your costs low, but it is important your employees share data. which network would provide you with the most economical solution?

Answers: 1

Answer

Computers and Technology, 23.06.2019 07:30

What is the penalty for violating section 1201 of title 17 chapter 21 of the us code

Answers: 1

Answer

You know the right answer?

Suppose that you have the following requirements for a university database that is used to keep

Questions