Computers and Technology, 06.06.2020 22:01, gaby8282

Consider the following database schema for music festival concerts. Underlined attributes denote a primary key. Only Genre can be NULL for any given tuple. FESTIVAL(FestivalName, FestivalID, Venue, StartDate, EndDate, Base TicketPrice) BAND(BANDNAME, BandID, Genre) PERFORMANCE (BID, FestID) And consider the following referential integrity constraint: For the PERFORMANCE relation, BID should reference a valid BandID in BAND, and FestID should reference a valid FestivalID in FESTIVAL. I. (60 pts) Write SQL data definitions to define appropriate table schemas for the festival concert database. Attribute domain choice is flexible, within reason (don't limit names or ids to a single character, for example). You do not need to write any code to add tuples to the database, and you can assume all the preliminary setup (Use command, etc.) before your data definition is already complete. II. (10 pts each) Write standard SQL queries to retrieve the following information from the database: a. List the band name and id of every band in the "Jazz" genre. b. List the festival name, venue, starting date, and ending date of every free festival. c. List the name of every festival at "KFC Yum! Center" that starts or ends in the year 2020. d. List every combination of band, by name, who has played (or is scheduled to play) at every venue. Each band, venue pair should be returned only once. To clarify potential confusion with query #4. if "The Miles Davis Quintet" played at five different individual festivals in Grant Park, Chicago, the pair ("Miles Davis Quintet", "Grant Park") should only be returned once by the query.

Answers: 1

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 18:00, ladyree8721

Which of the following physical laws can make the flow of water seem more realistic? a. motion b. gravity c. fluid dynamics d. thermodynamics

Answers: 2

continue

Computers and Technology, 23.06.2019 00:40, QueenKy6050

Consider the following statements: struct nametype{string first; string last; }; struct coursetype{string name; int callnum; int credits; char grade; }; struct studenttype{nametype name; double gpa; coursetype course; }; studenttype student; studenttype classlist[100]; coursetype course; nametype name; mark the following statements as valid or invalid. if a statement is invalid, explain why. a.) student. course. callnum = "csc230"; b.) cin > > student. name; c.) classlist[0] = name; d.) classlist[1].gpa = 3.45; e.) name = classlist[15].name; f.) student. name = name; g.) cout < < classlist[10] < < endl; h.) for (int j = 0; j < 100; j++)classlist[j].name = name; i.) classlist. course. credits = 3; j.) course = studenttype. course;

Answers: 1

continue

Computers and Technology, 23.06.2019 17:30, granta1

Write pseudocode to represent the logic of a program that allows the user to enter a value. the program multiplies the value by 10 and outputs the result.

Answers: 1

continue

Computers and Technology, 23.06.2019 18:20, Blossom824

What is wi-fi infrastructure? a metropolitan area network that uses radio signals to transmit and receive data a communications technology aimed at providing high-speed wireless data over metropolitan area networks a means by which portable devices can connect wirelessly to a local area network, using access points that send and receive data via radio waves includes the inner workings of a wi-fi service or utility, including the signal transmitters, towers, or poles and additional equipment required to send out a wi-fi signal

Answers: 2

continue

Do you know the correct answer?

Consider the following database schema for music festival concerts. Underlined attributes denote a p...