Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Task 1 devise a set of sample data to be used to populate the EliteVideo database. 0 You should include a number of members, a

image text in transcribed
image text in transcribed
Task 1 devise a set of sample data to be used to populate the EliteVideo database. 0 You should include a number of members, a number of movies and a number of Videos for some movies. 0 Make sure one member has the same primary key as your own student ID, and your name. This will have implications for the type of the attribute for Inem_num attribute we discussed last week. You will need to check all corresponding attributes linked to this. 0 Make sure that there is a Movie called 'Attack of the Killer Tomatoes', and one called 'Goosebumps'. - Make sure that there is a rental transaction for the member with your Student ID on 5f4/2021 for 'Attack of the Killer Tomatoes', 'Goosebumps' and one other movie. And that the videos were returned 2 days late. This will tie in with the PRICE sample data that you create. 0 Add some other further rental transactions as sample data

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Hospitality Management Accounting

Authors: Martin G Jagels, Michael M Coltman

8th Edition

0471092223, 9780471092223

More Books

Students also viewed these General Management questions

Question

3. What values would you say are your core values?

Answered: 1 week ago