Problem
i. The organization you work for, a shop selling motorbike spare parts, would like to be able to ensure that every product name and product code stored in the database is never duplicated in the database you are designing. Explain how you would achieve this.
ii. You have been tasked to design the data structures, queries, screens and reports of a new database. Describe the concepts of the object model design and how you would use this in your database design.
iii. What is a foreign key constraint? In your answer, explain the referential integrity constraint rules and the three possible actions.
iv. Explain what an oval shape represents in a use case diagram. Illustrate your answer with an example.