1. Write the MySQL statements. For the given MovieCo ERD below, write MySQL statements: MEMBERSHIP PK...
Fantastic news! We've Found the answer you've been seeking!
Question:
![1. Write the MySQL statements. For the given MovieCo ERD below, write MySQL statements: MEMBERSHIP PK MEM_NUM](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/64f82b7fbfe1c_1693985662114.jpg)
Transcribed Image Text:
1. Write the MySQL statements. For the given MovieCo ERD below, write MySQL statements: MEMBERSHIP PK MEM_NUM MEM_FNAME MEM_LNAME MEM_STREET MEM_CITY MEM_STATE MEM_ZIP MEM_BALANCE PRICE PK PRICE CODE -H--O PRICE_DESCRIPTION PRICE_RENTFEE PRICE_DAILYLATEFEE PK Your answer: RENTAL RENT NUM RENT_DATE FK1 MEM_NUM a) List all details about all members. Your answer: HO----X #H MOVIE PK MOVIE NUM MOVIE_TITLE MOVIE YEAR MOVIE_COST MOVIE_GENRE FK1 PRICE_CODE DETAILRENTAL PK,FK1 RENT NUM PK,FK2 VID NUM H-O DETAIL_FEE DETAIL_DUEDATE DETAIL_RETURNDATE DETAIL_DAILYLATEFEE PK VIDEO VID NUM VID_INDATE FK1 MOVIE_NUM b) List all details about price ordered by rent fee in ascending order. Hints: • Use the ORDER BY clause with PRICE_RENTFEE. 1. Write the MySQL statements. For the given MovieCo ERD below, write MySQL statements: MEMBERSHIP PK MEM_NUM MEM_FNAME MEM_LNAME MEM_STREET MEM_CITY MEM_STATE MEM_ZIP MEM_BALANCE PRICE PK PRICE CODE -H--O PRICE_DESCRIPTION PRICE_RENTFEE PRICE_DAILYLATEFEE PK Your answer: RENTAL RENT NUM RENT_DATE FK1 MEM_NUM a) List all details about all members. Your answer: HO----X #H MOVIE PK MOVIE NUM MOVIE_TITLE MOVIE YEAR MOVIE_COST MOVIE_GENRE FK1 PRICE_CODE DETAILRENTAL PK,FK1 RENT NUM PK,FK2 VID NUM H-O DETAIL_FEE DETAIL_DUEDATE DETAIL_RETURNDATE DETAIL_DAILYLATEFEE PK VIDEO VID NUM VID_INDATE FK1 MOVIE_NUM b) List all details about price ordered by rent fee in ascending order. Hints: • Use the ORDER BY clause with PRICE_RENTFEE.
Expert Answer:
Answer rating: 100% (QA)
Based on the provided ERD Ill write the MySQL statement... View the full answer
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1285196145
11th edition
Authors: Carlos Coronel, Steven Morris
Posted Date:
Students also viewed these databases questions
-
Write the SQL code to create the table structures for the entities shown in Figure P7.65. The structures should contain the attributes specified in the ERD. Use data types that would be appropriate...
-
The following tables provide a very small portion of the data that will be kept in the database. This data needs to be inserted into the database for testing purposes. Write the INSERT commands...
-
Why is emotional intelligence important for team performance and how can you use emotional intelligence to increase team performance?
-
Tort cases are so common that it is likely you or someone you know has been involved in a tort case. If so, share what the case was about, what the outcome was, and how you felt about the case and...
-
Write a report summarizing the characteristics of a web site with good usability.
-
What is the difference between luminescence, chemiluminescence, and bioluminescence?
-
Know what makes emerging markets attractive for international business. LO.1
-
A garage band wants to hold a concert. The expected crowd is 3,000. The average expenditure on concessions is $ 15. Tickets sell for $ 10 each, and the bands profit is 80% of the gate and concession...
-
Corentine company had $163,000 of accounts payable on September 30 and $138,000 on October 31. Total purchases on credit during October were $292,000. Determine how much cash was paid on accounts...
-
Better Fitness, Inc. (BFI) manufactures exercise equipment at its plant in Freeport, Long Island. It recently designed two universal weight machines for the home exercise market. Both machines use...
-
TABLE 2 The following table is about Slippery Rock's labor market. Use Table 2 on your answer sheet to fill-in-the blanks and to answer the following questions. All figures are in thousands. [16 pts]...
-
Explain the background and prerequisites of supply chain management. Present the basic factors for implementing cooperation between companies in relation to supply chain integration, and discuss what...
-
You're soliciting for a $2M non-commercial research and development effort to produce prototypes for a handheld virus scanner. There appears to be only one source capable of performing this...
-
1. what is the Nordic Model to prostitution?2. what are the advantages/disadvantages of the Nordic Model?3. many groups (including the ACLU) advocate for the decriminalization or legalization of sex...
-
A property owner is considering installing electric valves with automatic timers on their sprinkler systems. They estimate needing 45 valves and timers costing $65 for each set. Initial installation...
-
Will each scenario shift the aggregate supply curve, the aggregate demand curve, both, or neither? Items (4 items) (Drag and drop into the appropriate area below) A new technology makes workers more...
-
Problem! ? Number of shares acquired Purchase price per share Fair value per share at Dec 31, 20X2 Useful life of the automobiles Useful life of the equipment Useful life of the patent Subsidiary's...
-
Differentiate the following terms/concepts: a. Personality types and money attitudes b. Planners and avoiders c. Moderating and adapting to biases d. "Perfectible judges" and "incorrigible judges"
-
Create the table that would result from applying the SELECT and PROJECT relational operators to the CHARTER table to return only the CHAR_TRIP, CHAR_PILOT, and CHAR_COPILOT attributes for charters...
-
ROBCOR, Inc., whose sample data are contained in the database named Ch13_P4.mdb, provides "on demand" aviation charters using a mix of different aircraft and aircraft types. Because ROBCOR has grown...
-
Write the SQL code to delete the row for the person named William Smithfield, who was hired on June 22, 2004, and whose job code classification is 500.
-
40. The City of Pfeiffer starts the year of 2008 with the General Fund and an enterprise fund. The General Fund has two activities: education and parks/recreation. For convenience, assume that the...
-
41. Use the information in problem 40 to prepare the 2008 fund-based financial statements for the gov ernmental funds and the proprietary funds. A statement of cash flows is not required. Assume that...
-
37. The County of Maxnell decides to create a sanitation department and offer its services to the pub lic for a fee. As a result, county officials plan to account for this activity within the...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App