subject

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.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 23:30
What is the digital revolution and how did it change society? what are the benefits of digital media?
Answers: 1
question
Computers and Technology, 23.06.2019 11:00
Describe three characteristics of at-risk drivers. a. b. c. describe three characteristics of safe drivers. a. b. c. describe three driver errors that could cause a collision. a. b. c. how will this information affect you as a driver now and in the future? (2-3 sentences)
Answers: 2
question
Computers and Technology, 23.06.2019 12:00
What type of slide show is a dynamic and eye-catching way to familiarize potential customers with what your company has to offer? a. ole b. photo album c. brochure d. office clipboard
Answers: 2
question
Computers and Technology, 23.06.2019 18:00
Freya realizes she does not have enough in her bank account to use the debit card. she decides to use a credit card instead. which questions should freya answer before using a credit card? check all that apply. can i pay at least the minimum payment each month? can i make payments on time and avoid late fees? will i have to take out a loan? how much in finance charges can i afford to pay? should i talk to a consumer credit counseling service?
Answers: 1
You know the right answer?
Suppose that you have the following requirements for a university database that is used to keep trac...
Questions
question
Chemistry, 01.09.2019 19:20