Please provide shorthand in creating access database. Please make sure database

Question

Please provide shorthand in creating access database.

Please make sure database is normalized.

Please identify entities, attributes, primary key, and functional dependencies.

Runner

Runner #

Runner First Name

Runner Last Name

Runner Phone #

Runner Address

Runner City

Runner Zip Code

Time Race Completed

Money Raised

Place Finished

Race Name (may be more than one)

Donated

Donor

First Name

Last Name

Phone #

Runner Number

Amount Donated ($)

Race

Race ID

Name of Race

Runner ID

Place Finished (#)

Runner Time

Amount raised ($)

Order of race in schedule

Explanation / Answer

create access database-

create table Runner(Runner_Number int NOT NULL,First_Name varchar(100),Last_Name varchar(100) NOT NULL PRIMARY KEY,Phone int NOT NULL,Address varchar(200),City varchar(30),Zip_Code int,Time_Race_Completed TIMESTAMP PRIMARY KEY,Money_Raised int PRIMARY KEY,Place_Finished int NOT NULL PRIMARY KEY,Race_Name varchar(20) NOT NULL PRIMARY KEY,Donated int PRIMARY KEY,PRIMARY KEY(Runner_Number ));

create table Donor(First_Name varchar(100),Last_Name varchar(100) NOT NULL FOREIGN KEY REFERENCES Runner(Last_Name) ,Phone int NOT NULL,Runner_Number int FOREIGN KEY REFERENCES Runner(Runner_Number),Donated int FOREIGN KEY REFERENCES Runner(Donated));

create table Race(Race_ID int NOT NULL,Race_Name varchar(20) NOT NULL FOREIGN KEY REFERENCES Runner(Race_Name),Runner_Number int FOREIGN KEY REFERENCES Runner(Runner_Number),Place_Finished int NOT NULL FOREIGN KEY REFERENCES Runner(Place_Finished),Runner_Time TIMESTAMP FOREIGN KEY REFERENCES Runner(Time_Race_Completed),Amount_raised NOT NULL FOREIGN KEY REFERENCES Runner(Money_Raised),Order_of_race_in_schedule int);

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.