You have been commissioned to develop a database system

| October 14, 2019


You have been commissioned to develop a database system that is capable of growing as LUSH does. The database needs to keep a record of: • All stock • All stock movements • All hires • All fees and charges made • Regular hirers • Hiring history Further, it should be possible to identify items that are: • Available for hire • Under repair • Out on loan Regular transactions that need to be recorded include: • New hirers • New stock • New loan • Loan returns • Items being repaired • Fees and charges incurred by whom and for what Reports that are required include: • Items on loan • Items in repair
• Overdue hires • Indebted hirers Steps you need to take to develop your database application 1. Complete the analysis and design of your database application
a. List the business rules for your system (do not get distracted by red herrings in the scenario!). b. Identify the entities and relationships in your system. c. Identify the characteristics of the entities in your system. d. Develop an ER diagram to model your system. e. Develop table structures from the ER model. f. Conduct a dependency analysis of the table structures and normalize your tables where appropriate, to at least 3NF. g. Create a data dictionary for your database.
2. Implement your project
a. Create a database that hosts your application data b. Create tables in your database. These must be consistent with your design.  c. Populate all tables with sample data (at least 5 entries in each) d. Create the required views, stored procedures etc. to meet the requirements of your system
You need to be able to demonstrate that your database application meets the requirements detailed in the scenario as well as be consistent with the model you have developed.  
Submission Requirements Your assignment should be composed of the following parts: 1. Project document which includes the following:
1.1. A list of the business rules; 1.2. ER Diagram(s) prepared using software such as MS Office Visio or any other ER diagram tool. These should include all necessary information about the entities, attributes and relationships. Please provide clear and easy-to-read screenshot of your ER Diagram(s). If you draw your diagram(s) in MS Visio, please submit the Visio file too; 1.3. Data dictionary in the format shown in the lecture notes; 1.4. Database design and table structures showing table names, as well as any related entity integrity and referential integrity constraints. Include in the table structures attribute data types, sizes, primary keys, foreign keys and any other relevant information; 1.5. Diagrams showing the dependency analysis for each of the tables. You need to demonstrate that all tables are in 3NF. Show the process of normalization including tables in 1NF, 2NF and 3NF respectively. Please refer to the examples in lecture notes; 1.6. The SQL code you used to: 1.6.1. Create and populate the database; 1.6.2. Process each of the transactions identified in the assignment specification; 1.6.3. Create each of the reports identified in the assignment specification

Order your essay today and save 20% with the discount code: ESSAYHELP
Order your essay today and save 20% with the discount code: ESSAYHELPOrder Now