The following Entity Relationship Diagram (ERD) captures the data that needs to be stored for Elite...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following Entity Relationship Diagram (ERD) captures the data that needs to be stored for Elite Video, a small startup company providing concierge DVD kiosk service. Elite Video can own several copies (VIDEO) of each movie (MOVIE). For example, the store may have 10 copies of the movie "The Cesar Family Christmas". "The Cesar Family Christmas" would be one MOVIE and each copy would be a VIDEO. Each movie has a price code which determines the fee for renting that movie and the daily fee for returning it late. A rental transaction (RENTAL) involves one or more videos being rented to a member (MEMBERSHIP). A video can be rented many times over its lifetime, therefore, there is a many-to-many relationship between RENTAL and VIDEO. DETAILRENTAL is the bridge table which breaks this many-to-many relationship into two 1-to-many relationships. 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 RENTAL RENT NUM RENT_DATE FK1 MEM_NUM HO----O HI MOVIE PK MOVIE NUM MOVIE_TITLE MOVIE_YEAR MOVIE_COST MOVIE_GENRE FK1 PRICE_CODE DETAILRENTAL RENT NUM PK,FK1 PK,FK2 VID NUM FH-O DETAIL_FEE DETAIL DUEDATE DETAIL_RETURNDATE DETAIL_DAILYLATEFEE PK VIDEO VID_NUM VID_INDATE FK1 MOVIE_NUM Problem #1 (30pts): Translate the above ERD into a relational schema (a set of tables) and implement it in Access. Make sure you enforce all PK and FK constraints illustrated in the above ERD. Recall that in Access, FK constraints are enforced by creating relationships between tables and enforcing referential integrity for each relationship. Choose appropriate data types for your fields such that they can store the data illustrated below and insert this data into your table. The following Entity Relationship Diagram (ERD) captures the data that needs to be stored for Elite Video, a small startup company providing concierge DVD kiosk service. Elite Video can own several copies (VIDEO) of each movie (MOVIE). For example, the store may have 10 copies of the movie "The Cesar Family Christmas". "The Cesar Family Christmas" would be one MOVIE and each copy would be a VIDEO. Each movie has a price code which determines the fee for renting that movie and the daily fee for returning it late. A rental transaction (RENTAL) involves one or more videos being rented to a member (MEMBERSHIP). A video can be rented many times over its lifetime, therefore, there is a many-to-many relationship between RENTAL and VIDEO. DETAILRENTAL is the bridge table which breaks this many-to-many relationship into two 1-to-many relationships. 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 RENTAL RENT NUM RENT_DATE FK1 MEM_NUM HO----O HI MOVIE PK MOVIE NUM MOVIE_TITLE MOVIE_YEAR MOVIE_COST MOVIE_GENRE FK1 PRICE_CODE DETAILRENTAL RENT NUM PK,FK1 PK,FK2 VID NUM FH-O DETAIL_FEE DETAIL DUEDATE DETAIL_RETURNDATE DETAIL_DAILYLATEFEE PK VIDEO VID_NUM VID_INDATE FK1 MOVIE_NUM Problem #1 (30pts): Translate the above ERD into a relational schema (a set of tables) and implement it in Access. Make sure you enforce all PK and FK constraints illustrated in the above ERD. Recall that in Access, FK constraints are enforced by creating relationships between tables and enforcing referential integrity for each relationship. Choose appropriate data types for your fields such that they can store the data illustrated below and insert this data into your table.
Expert Answer:
Answer rating: 100% (QA)
Ans Step 1 CREATE SCHEMA elitevideo Step 2 CREATE TABLE elitevideomembership memnum INT NOT NULLmemfname VARCHAR45 NULLmemlname VARCHAR45 NULLmemsreet ... View the full answer
Related Book For
Systems analysis and design
ISBN: ?978-1118808177
5th edition
Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth
Posted Date:
Students also viewed these accounting questions
-
EliteVideo is a startup company providing concierge DVD kiosk service in upscale neighborhoods. EliteVideo can own several copies (VIDEO) of each movie (MOVIE). For example, the store may have ten...
-
EliteVideo is a startup company providing concierge DVD kiosk service in upscale neighborhoods. EliteVideo can own several copies (VIDEO) of each movie (MOVIE). For example, the store may have ten...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Sunland Company has the below information for accruals for the year ended December 31st, 2022. the company adjusts its accounts annually. Chapter 4 Homework e Question 6 of 7 Current Attempt in...
-
The following section is taken from Mareskas balance sheet at December 31, 2013. Current liabilities Interest payable ............. $ 40,000 Long-term liabilities Bonds payable (8%, due January 1,...
-
The amplitude of a surface wave for which \(\lambda=0.050 \mathrm{~m}\) is \(5.0 \mathrm{~mm}\) at a distance of \(1.0 \mathrm{~m}\) from a point source. What is the amplitude of the wave (a) 10 m...
-
Discuss the various sources and strategies for integrating cost and value.
-
Wilkes and Chevron are partners in a tennis shop. They have agreed that Wilkes will operate the store and receive a salary of $104,000 per year. Chevron will receive 10 percent interest on his...
-
What is the future of global trade and how does it affect the US economy and (another country that you'd like to work in someday? Please review the following article...
-
A block diagram for internal model control, a control technique that is considered in Chapter, is shown in Figure. Transfer function Gp denotes the process model, while Gp, denotes the actual process...
-
Dried Fruit Corp. has had a valid S Corp election in effect at all times since its incorporation. The Dried Fruit Corp. stock is owned one-third by Raisin and two-thirds by Prune. All shareholders...
-
What are three forms of exporting?
-
What is FDI? What are its three basic forms? What are the relative advantages and disadvantages of each?
-
What are three specialized entry modes for international business, and how do they work?
-
What is international franchising? What are its advantages and disadvantages?
-
What is international licensing? What are its advantages and disadvantages?
-
An object of mass 71.3 kg is in free fall. At height 228.0 meters, the object is traveling at 11.3 m/s. How fast will the object be traveling when it descends to a height of 133.0 meters? ( provide...
-
Refer to the situation described inBE 18-13, but assume a 2-for-1 stock split instead of the 5% stock dividend. Prepare the journal entry to record the stock split if it is to be effected in the form...
-
What does a data couple depict on a structure chart? A control couple?
-
Describe five types of outputs.
-
Why should the system request be created by a businessperson as opposed to an IS professional?
-
Sketch a hypothetical scatterplot for a sample of size 10 for two random variables with a population correlation of (a) 1.0; (b) -1.0 ; (c) 0.9; (d) -0.5 ; (e) 0.0.
-
Using the data in Exercise 3.3: a. Construct a \(95 \%\) confidence interval for \(p\). b. Construct a \(99 \%\) confidence interval for \(p\). c. Why is the interval in (b) wider than the interval...
-
Explain why the differences-of-means estimator, applied to data from a randomized controlled experiment, is an estimator of the treatment effect.
Study smarter with the SolutionInn App