Reference no: EM132971840

H/615/1622 Database Design & Development Systems - BTEC HND IN COMPUTING

Learning outcome 1: Use an appropriate design tool to design a relational database system for a substantial problem.
Learning outcome 2: Develop a fully functional relational database system, based on an existing system design.
Learning outcome 3: Test the system against user and system requirements.
Learning outcome 4: Produce technical and user documentation.

Scenario

Lotus Inc. produces cosmetic products. The below mentioned product information is stored: cosmetic product name, productId and quantity available. These products are made up of many elements. Each element can be supplied by one or more suppliers. A supplier has supplierId , address and supplier name A supplier can exist without providing element. The following element information is kept: elementId, element name, description, suppliers who supply them, and products in which they are used. An element does not have to be associated with a supplier. An element does not have to be associated with a product. Not all elements are used in products but a product cannot exist without element.

Create a database solution to show how you would capture this information for this company. You can assume other relevant details. Create a complete system that could track the above information with relevant user and system requirements.

Assignment Task
Based on the context above, complete the followings.

Part 1
Produce a Report:
1. The design of the relational database system using appropriate design tools and techniques. It should contain at least four interrelated tables.
2. Clear statements of user and system requirements.
Produce a more detailed document, so you will produce a comprehensive design for a fully functional system which will include interface and output designs, data validations and cover data normalization and assess the effectiveness of design in relation to user and system requirements.

Part 2
Once the designs accepted, you have to develop the database system using evidence of user interface, output and data validations and querying across multiple tables.
You want to include more than just the basics so you will implement a fully functional database system which will include system security and database maintenance features. You have decided to implement a query language into the relational database system.

1. Assessing whether meaningful data has been extracted through the use of query tools to produce appropriate management information.
2. Evaluating the effectiveness of the database solution in relation to user and system requirements and suggest improvements.
3. Once the system has been developed, you will test the system
4. You will produce a brief report assessing the effectiveness of the testing, including an explanation of the choice of test data used.

Part 3
Lastly you will produce technical and user documentation.

You want to provide some graphical representations for ease of reference in the technical guide, so you have decided to produce a technical and user documentation for a fully functional system, including diagrams showing movement of data through the system, and flowcharts describing how the system works.

Attachment:- Database Design & Development Systems.rar