Reference no: EM132672474

8Unit 04 Database Design & Development - Higher Nationals in Computing

Assignment - Stock Management System (Web/Desktop)

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.

Assignment brief

Case Study

ABC stock management company is a privately run stock warehouse based in Katunayaka. They want you to supply them with a database to keep records of their stock details and client details.. ect.

Task 1

1.1 The design of the relational database system using appropriate design tools and techniques. It should contain at least five interrelated tables.

1.2 You will produce a comprehensive design for a fully functional system which will include interface to Stock Management System and output designs, data validations and cover data normalization. Clear statements of user and system requirements.

Task 2

2.1 Once the designs have been accepted you have been asked to develop the database system using evidence of user interface, output and data validations and querying across multiple tables.

2.2 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.

2.3 You have decided to implement a query language into the relational database system. Assessing whether meaningful data has been extracted through the use of query tools to produce appropriate management information.

2.3.1 For each client, get the client's name and the list of the client's investments with stock name, current price and last dividend per share.

2.3.2 Get the list of all clients and their share investments, showing the client name, and for each stock held by the client, the name of the stock, total number of shares held, and the average purchase price paid by the client for the stock. Average price is the total purchase value paid by a client for a given stock (value=qty* selling price) divided by the total quantity held by the client.

2.3.3 For each stock traded in New York, find the quantity held by each client, and its current value (value=qty* current price). Display stock (company) name, client name, number of shares held, and the current value of the shares.

Task 3

3.1 Evaluating the effectiveness of the database solution in relation for educational organizational environment and system requirements, and suggest improvements.

3.2 Once the system has been developed, you will test the system against user and system Requirements, including an explanation of the choice of test data used.

3.3 Produce technical and user documentation which will be given to the Stock Management System. Provide some graphical representations for ease of reference in the technical guide and 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:- Stock Management System.rar