Toy Planet Database Design Concepts
Purpose of this assignment The toy planet database design concepts consider the skills required to perform effectively as a Database design and development employee. To give learners opportunities to develop an understanding of the concepts and issues relating to databases and database design as well as the practical skills to translate that understanding into the database design and creation of complex databases. Case Scenario An online toy store Toy Planet needs to have a database designed for it to be able to cater to its customers. It has approached Data Sol Ltd to develop a database for the same. DataSol did a requirements gathering phase and identified the following key requirements: The system should be able to register and save details of all customers like customer name and address. Each customer is identified by a unique customer number. Details of each toy/product will be stored in the system with unique product number, product description a...