Design and Construct a Database - Computer Science Assignment Help

Assignment Task

Aim of the Assignment
Your task in this assignment is to design and construct a database and a set of Web pages that can be used to retrieve and display some of the data. The submission deadline is 5.00pm on Friday 23rd April 2021. This exercise is worth 80% of the overall marks for CS952.

Task
Read the following description of a database specification. From the specification, produce the following:
• An enhanced entity relationship model.
• A list of table structures produced by logical design based on the above enhanced entity relationship model.
• The SQL code to construct and populate only sufficient tables to carry out the query part of the exercise. The database can be built using either Oracle or MySQL.
• A set of web pages that execute the queries and display the results.
• A critique of your design and implementation.

Database specification
The manufacturing company system.
A database is required to store information concerning a manufacturing company as follows:

A database is to be used by an organisation to store data about orders. Each order is identified by an order number. Each order has an order date and contains a number of order lines. Each order line specifies a part number and a quantity for the part. Parts are either manufactured by the organisation or 'bought in'. In the case of 'bought in' parts it is important to store information about the cost of the part. Parts that are ‘bought in’ are obtained from suppliers whose names and addresses are stored in the database. In addition, each supplier has a bank account with a branch code and account number. It is possible that some parts held by the organisation have not been
ordered. A supplier can supply many parts and the same part can be sourced from a number of suppliers. Some parts are composites; i.e. they are assemblies of other parts. A single part may be used in a number of different composite parts. Manufactured parts may be assembled to order or may be made in bulk and then held in stock. For stock parts, it is important that the location is stored. Parts that are assembled to order require a lead time to be recorded.

Process:
4.1 Enhanced entity relationship model
The first step in this process is to construct an enhanced entity relationship diagram. Read the above specification and write down a list of the entities and attributes. For each entity indicate the identifier and write a sentence to describe the significance of the entity. Indicate any supertype/subtype hierarchies. Make a note of necessary assumptions. Draw an enhanced entity relationship diagram.

This Computer Science Assignment has been solved by our Computer Science experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.