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:
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
-
Carry out a manual calculation to verify the option prices in Example 29.2.
-
The duration of a bond that makes an equal payment each year in perpetuity is (1 + yield)/ yield. Prove it.
-
What are the primary objectives of (a) the review of the system, (b) a transaction walk-through review, (c) a preliminary evaluation, (d) tests of compliance, and (e) evaluation of the system?
-
Many accounting and accounting-related professionals are skilled in financial analysis, but most are not skilled in manufacturing. This is especially the case for process manufacturing environments...
-
You have a Microsoft 365 E5 subscription that contains an eDiscovery case named Case1. You create a search job in Case1. You need to download the exported search results. How long are the search...
-
Merchant Company had the following foreign currency transactions: 1. On November 1, 20X6, Merchant sold goods to a company located in Munich, Germany. The receivable was to be settled in European...
-
You are to implement a password manager program that creates and stores a password entry. The program first displays a welcome message and then asks the user to input the website name, username,...
-
Match each term with its definition. Term 1. Categorical Data 2. Trend 3. Proportion 4. Numerical data 5. Scatterplot 6. Time series data Definition a. The values of two variables, each plotted on...
-
This chapter described the concept of a firms balance sheet. Individuals and households have balance sheets as well, and the broad categories in them are the same as those on a firms balance sheet....
-
Accounting information systems a. are always computerized. b. report only financially related information. c. are information systems that record, process, and report on transactions to provide...
-
The appropriate amount of an Allowance for Doubtful Accountants (that serves as a contra asset to Accounts Receivable) is generally determined by figuring out how long the underlying receivables have...
-
The acronym ETL, in the process of readying data for use in data analysis, refers to what three words? a. Extrapolate, transform, and learn b. Extrapolate, transpose, and load c. Extract, transform,...
-
Bright Inc is a big publicly traded company on the Ghana Stock Exchange. Based on a GHS 100,000 market feasibility study, the firm has considered the production and sale of new product line which was...
-
Imagine that your best friend knows you are taking a psychology course and wonders what psychology is all about. How would you define psychology for your friend? Write an essay on the discipline of...
-
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?
-
(a) Complete a steady-state simulation of the vinyl-chloride process in Figure 2.6. First, create a simulation flowsheet. Assume that: Cooling water is heated from 30 to \(50^{\circ} \mathrm{C}\)...
-
For the monochlorobenzene separation process in Figure 7.14, the results of an ASPEN PLUS simulation are provided in the multimedia modules under ASPEN \( ightarrow\) Principles of Flowsheet...
-
Complete a simulation of the entire process for the hydrodealkylation of toluene in Figure 6.14. Initially, let the purge/recycle ratio be 0.25 ; then, vary this ratio and determine its effect on the...
Study smarter with the SolutionInn App