Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(a) (b) (c) In developing a Video Rental System for a local video store, the owner of the store suggests using a customer's home

image text in transcribed 

(a) (b) (c) In developing a Video Rental System for a local video store, the owner of the store suggests using a customer's home telephone number as the identifier for its customers. Explain if you agree or disagree with the owner's suggestion. (6 marks) The business rules expressed in the following ERD fragment are "A staff member must man age one or more other staff members" and "A staff member must be managed by an other staff member". Is there anything wrong with the business rules? Explain why or why not. STAFF manages is managed by (4 marks) Using examples of entity sets and entity instances, clearly explain, with the help of a diagram, a relationship that a computer may (optional) be assigned to one staff member and a staff member may only be assigned at most one computer. You need to show the different scenarios possible in your diagram (4marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

a Whether using a customers home telephone number as the identifier for customers in a Video Rental System is a good idea depends on several factors H... 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

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

Students also viewed these Programming questions

Question

public int sizeBelowDepth ( int k ) { MYINTSET

Answered: 1 week ago

Question

What was the accounting Big Bang in Japan?

Answered: 1 week ago