First Access Assignment
Answers to Problems.
#1: Yes, there is enough data.
#2: Yes, there is enough data.
#3: No, there is not enough data, you would need to add the publisher to the table.
#4: Yes, there is enough data only if the edition refers to the year published. If the edition refers to just that, then there is not enough data.
#5: You would need the Qty. on Hand, the Reorder Point, and the Product Name and/or Number in your table.
#6: You would need the Item and Price in your table.
#7: You would need the Item, Selling Price, and Cost in the table.
#8: You would need the Customer Name, the car make/model, Value of the car, and the Customer Rating.
#9: I would probably want their Name, Relationship, Date of Birth, Date of Death (if applicable), Place of Birth, Anniversary Date, Spouse Name, Chidren's Name(s).
#1: Yes, there is enough data.
#2: Yes, there is enough data.
#3: No, there is not enough data, you would need to add the publisher to the table.
#4: Yes, there is enough data only if the edition refers to the year published. If the edition refers to just that, then there is not enough data.
#5: You would need the Qty. on Hand, the Reorder Point, and the Product Name and/or Number in your table.
#6: You would need the Item and Price in your table.
#7: You would need the Item, Selling Price, and Cost in the table.
#8: You would need the Customer Name, the car make/model, Value of the car, and the Customer Rating.
#9: I would probably want their Name, Relationship, Date of Birth, Date of Death (if applicable), Place of Birth, Anniversary Date, Spouse Name, Chidren's Name(s).