Create a preliminary design for a possible two-table

Assignment Help Computer Engineering

Reference no: EM132142064

Suppose that you need to create two-table database to record information for a DVD rental kiosk. The following information needs to be recorded.

For all movies: Movie number, title, category, rental rate, and whether or not it is available for rent; for all rented movies, the customer who rented the movie and the due date will also need to be recorded.

For all customers: Customer number, name, address, city, state, ZIP code, and phone number.

Create a preliminary design (use Figure 12-14 in the book for reference if needed) for a possible two-table database for this scenario (Movie table and Customer table), locating the fields in the most appropriate tables and having a minimum of redundancy.

Reference no: EM132142064

Questions Cloud

Describe complexity economics in detail : Describe complexity economics in detail. What do you see as the strengths and weaknesses of this approach to macroeconomics? Explain your answer fully.

Prepare a wealth report for a prospective shareholder : MBA403 Financial and Economic Interpretation and Communication Assessment - Wealth report, Kaplan Business School, AUSTRALIA

Is this a good design choice and why : Suppose that new, more powerful arithmetic instruction are added to the instruction set.

Describe the effects of employment discrimination on wages : Describe the effects of employment discrimination on wages. How could this impact ones business decisions in relation to labor costs?

Create a preliminary design for a possible two-table : Create a preliminary design for a possible two-table database for this scenario locating the fields in the most appropriate tables.

Describe both law of demand and law of supply : Describe both "Law of Demand" & "Law of Supply" regarding price changes relative to the substitution and income effect? In your response.

Invite the largest set of friends possible : Your goal is to invite the largest set of friends possible such that no pair of invited friends dislike each other.

Why were not you motivated : Describe a situation where you were no motivated at all... What was missing? Why weren't you motivated? (again use a work situation if you can).

Describe the three forms of price discrimination : Describe the three forms of price discrimination and give examples of where each kind is applied. What would prevent a firm attempting to price discriminate.

User Account

All Pages