1. Write MySQL statements to create a database named MovieCo for the following (partial) ERD and...
Fantastic news! We've Found the answer you've been seeking!
Question:
![1. Write MySQL statements to create a database named MovieCo for the following (partial) ERD and Relational](https://dsd5zvtm8ll6.cloudfront.net/questions/2023/10/6538ac8603076_1698212998779.jpg)
![2. Now write MySQL statements to insert data into the two tables you just | created. PRICE Price_Code](https://dsd5zvtm8ll6.cloudfront.net/questions/2023/10/6538ac9add887_1698213019959.jpg)
Transcribed Image Text:
1. Write MySQL statements to create a database named MovieCo for the following (partial) ERD and Relational Database Schema. You will need to write MySQL statements to create the database and two tables in that database. Figure 1: MovieCo ERD Table Name PRICE PKPRICE CODE Relational Database Schema: Field PRICE CODE PRICE DESCRIPTION PRICE RENTFEE MOVIE PRICE DESCRIPTION PRICE RENTFEE PRICE DAILYLATEFEE PRICE DAILYLATEFEE MOVIE NUM MOVIE TITLE MOVIE YEAR MOIVE COST MOVIE GENRE PRICE_CODE Hox MOVIE PK MOVE NUM MOVIE TITLE MOVIE YEAR MOVIE COST GENRE MOVIE FKY PRICE CODE Type CHAR(2) VARCHAR(20) DECIMAL (5,2) DECIMAL (5.2) CHAR(3) VARCHARGE) CHAR(4) DECIMAL (5,2) VARCHAR(50) CHAR(2) Description PRIMARY KEY NOT NULL PRIMARY KEY NOT NULL FOREIGN KEY (PRICE_CODE) REFERENCES PRICE(PRICE_CODE) 2. Now write MySQL statements to insert data into the two tables you just | created. PRICE Price_Code Price_Description Price_Rentfee Price Dailylatefee 01 Standard 02 New Release MOVIE Movie Num Movie Name 00001234 The Cesar Family Christmas 00001235 Smokey Mountain Wildlife 2 3.5 1 3 Movie_Year Movie_Cost Movie_Genre Price_Code 39.95 FAMILY 59.95 ACTION 2014 2011 02 01 1. Write MySQL statements to create a database named MovieCo for the following (partial) ERD and Relational Database Schema. You will need to write MySQL statements to create the database and two tables in that database. Figure 1: MovieCo ERD Table Name PRICE PKPRICE CODE Relational Database Schema: Field PRICE CODE PRICE DESCRIPTION PRICE RENTFEE MOVIE PRICE DESCRIPTION PRICE RENTFEE PRICE DAILYLATEFEE PRICE DAILYLATEFEE MOVIE NUM MOVIE TITLE MOVIE YEAR MOIVE COST MOVIE GENRE PRICE_CODE Hox MOVIE PK MOVE NUM MOVIE TITLE MOVIE YEAR MOVIE COST GENRE MOVIE FKY PRICE CODE Type CHAR(2) VARCHAR(20) DECIMAL (5,2) DECIMAL (5.2) CHAR(3) VARCHARGE) CHAR(4) DECIMAL (5,2) VARCHAR(50) CHAR(2) Description PRIMARY KEY NOT NULL PRIMARY KEY NOT NULL FOREIGN KEY (PRICE_CODE) REFERENCES PRICE(PRICE_CODE) 2. Now write MySQL statements to insert data into the two tables you just | created. PRICE Price_Code Price_Description Price_Rentfee Price Dailylatefee 01 Standard 02 New Release MOVIE Movie Num Movie Name 00001234 The Cesar Family Christmas 00001235 Smokey Mountain Wildlife 2 3.5 1 3 Movie_Year Movie_Cost Movie_Genre Price_Code 39.95 FAMILY 59.95 ACTION 2014 2011 02 01
Expert Answer:
Answer rating: 100% (QA)
To insert the data into the tables PRICE and MOVIE that youve just creat... View the full answer
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these databases questions
-
Consider the following brands, and discuss the extendibility of each: Grey Goose Vodka, Victoria's Secret, BlackBerry, Las Vegas Kate Spade
-
3. What is stored in numList after the following code executes? (15 Points) int numList[6] = {25, 37, 62, 78, 92, 13}; int *listPtr = numList; int *temp = listPtr + 2; int num; *listPtr = *(listPtr +...
-
4. Consider that you are a manager at a local Chick-fil-a. You have been approved for a loan to make improvements to your store. Provide examples of costs/receipts for the variables we covered in...
-
2. Evaluate the following definite integrals (a) (2x - 6x) dx /6 (b) 16 cos 3t + 2 sin 3t dt x+1 2 da
-
A piston/cylinder contains helium at 110 kPa at ambient temperature 20C, and initial volume of 20 L as shown in Fig. P12.119. The stops are mounted to give a maximum volume of 25 L and the nitrogen...
-
A manager must decide how many machines of a certain type to buy. The machines will be used to manufacture a new gear for which there is increased demand. The manager has narrowed the decision to two...
-
Examine the nature of change when the organisation is conceptualised as a human living system? L01
-
Bond Transactions Brand Company issued $1,000,000 face value, eight-year, 12% bonds on April 1, 2010, when the market rate of interest was 12%. Interest payments are due every October 1 and April 1....
-
Sheridan Company has gathered the following information concerning one model of shoe: Variable manufacturing costs $30000 Variable selling and administrative costs $12000 Fixed manufacturing costs...
-
Lincoln Petroleum has the following data in connection with Lease A: REQUIRED: Lincoln Petroleum is sole owner of the working interest. If reserves are determined to be 11,000 barrels, is the well...
-
Complete the growth estimates for the years 2022 to 2025 as follows: a. In cell C16, create a formula that adds 1 to the growth rate (cell C14) and multiplies the result by the estimated profit from...
-
What type of corporate governance does Uniqlo utilise? (e.g. Agency Relationships, Ownerships Concentration, Membership of the Board of Directors (insiders, related outsiders, outsiders)). What type...
-
Air at a dbt (dry bulb temprature) of 30 C and a relative humidity of 30% is conveyed through a heated dryer where it is heated to a dbt of 80 C. Then it is conveyed through a bed of granular pet...
-
Do you think McDonald's entry strategy was appropriate for the Indian market? Explain there strategy according to Indian market.
-
Please do detailed market strategy and target market for this device as described below. the target area is east African market. "Safe locater" is a company that will be formed committed to develop...
-
how do you define technical performance measures(TPM)? what are the key differences between design department parameters (DDP) andTechnical performance measures (TPM). References if possible
-
A non-dividend paying stock follows a lognormal distribution. The current stock price is 40. The stocks continuously compounded expected rate of return is 0.1, and its volatility is 0.25. Construct a...
-
A certain Christmas tree ornament is a silver sphere having a diameter of 8.50 cm. Determine an object location for which the size of the reflected image is three-fourths the size of the object. Use...
-
Describe Agile Usage-Centered Design. Describe the Planning Game. Compare and contrast these two requirements determination techniques.
-
What are some reasons why one activity may have to precede another activity before the second activity can begin? In other words, what causes precedence relationships between project activities?
-
What types of security policies and procedures does your university have in place for campus information systems?
-
Select your weakest style and try to identify two different learning activities which fit with this style, but that you would normally avoid. ? lop1
-
Log your experiences and in particular what you have learned about these new learning activities. ? lop1
-
Consider your development over the past year: do you feel that your strengths are in planning your learning or in learning opportunistically? Choose your weaker approach, and identify how you could...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App