Hi there,

 

Kindly assist me to answer this questions, i'm having issues with some so i would to check the answers. Thanks.

 

 

You have been given the following specifications of a simple database for keeping track of venues

and events at the Olympics (note that primary keys are shown underlined, foreign keys in bold).

You should run your SQL to demonstrate that it works correctly, and paste the queries into your

document.

 

VENUE (VenueName, Location, Capacity)

EVENT (EventName, ScheduledStart, VenueName)

 

a. Give the SQL to create the VENUE table. Choose appropriate data types. None of the attributes

should be allowed to be null. Include the primary key constraint.

b. Give the SQL to create the EVENT table. Use appropriate data types, and include the primary key

and foreign key constraints. Referential integrity should be set such that a venue may not be

deleted from the database if there is an event recorded in it.

c. Give the SQL to add the Maracana Stadium to the VENUE table. The stadium is located in

Avenida Maracana and has a capacity of 78,838.

d. Give the SQL to add an attribute Sport to EVENT. (Possible values include Athletics, Swimming,

Tennis, and many others.)

e. Give the SQL to record the fact that the Maracana Stadium now has capacity 90,000.

SophiaPretty

(5)

Status NEW Posted 18 Nov 2017 01:11 PM My Price 8.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer