Question: (a) Can the database tell us a Person's first name? If so, how? If not, what would we need to change in the diagram to

 (a) Can the database tell us a Person's first name? If

(a) Can the database tell us a Person's first name? If so, how? If not, what would we need to change in the diagram to allow this to happen? (b) Can a Person be uniquely identified based on their name alone? If so, why? If not, what is the minimum we need to uniquely identify any Person? (c) Can an Employee also be a Thief? Why or why not? (d) Can there be any Person who is neither an Employee nor a Thief? Why or why not? (e) Can there be any Thief who does not Steal any Items? Why or why not? (f) Are there any descriptive attributes in this diagram? If so, which one(s)? If not, explain how we would recognize them in the diagram. (g) Are there any local attributes in this diagram? If so, which one(s)? If not, explain how we would recognize them in the diagram. (h) Are there any weak entity types in this diagram? If so, which one(s)? If not, explain how we would recognize them in the diagram. (i) Must every Thief have a credit card number stored in the database? Why or why not? (j) Can the same Person buy a cookie on February 10, 2022 and buy another cookie on February 11, 2022? Why or why not? (Assume "cookie" is in the domain of Item.name.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!