Grantham University Chapter 5 Database Management Assignment

User Generated

ubzrjbexpbafhgyvat

Computer Science

Grantham University

Description

For this assignment you need to complete questions A _ H on p. 136 of Chapter 5.

Submit your completed work for this assignment to the Dropbox of D2L in a timely manner. I don't accept your works through means (e-mails, jump dives,, etc.) other than the Dropbox in D2L. No late works to be accepted.

Unformatted Attachment Preview

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Running head: DATABASE MANAGEMENT

Database management
Student's Name
Institutional Affiliation
Date

1

DATABASE MANAGEMENT

2

a)
Team: Team Number & Team Name
Coach: Team Number & Coach Name
Work Experience: Team Number & Coach Name
Bats: Team Number & Serial Number
Player: Player Number
Affiliation: Player Number & Team Number

b)
Primary key of Team is Number of Team, and the alternative key is the number of Team along
with Team Names.
Primary key of Coach is Number of Team along with the name of Coach, and the alternative key
is Number of Team along with the name of Coach.
Primary key of Work Experience is Number of Team along with Coach Name, and the
alternative key is Team Number along with Coach Name.
Primary key for Bats is Number of Team along with Number of Serial, and the alternative key is
Number of Team along with Number of Serial.
Primary key of Player is Number of Player, and the alternative key is Number of Playe...


Anonymous
Just what I needed…Fantastic!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags