Assignment 1: Database Fundamentals

Length: 1500 Words.

Outcomes

1. To demonstrate knowledge of broad business principles with

2. To depth of understanding of at least one business discipline

3. To develop effective oral and written communication skills

4. To develop the skills to demonstrate a broad understanding of business principles and demonstrate depth in at least one discipline

5. To develop the skills to allow the acquisition and synthesising of information within a complex professional setting

6. To develop and apply skills in critical thinking, complex problem solving and decision making

DESCRIPTION:

Consider a web based automobile producing company which produces vehicles, such as Cars, Trucks and Bikes. You first need to provide a conceptual discussion of it's business operations, identify the requirements and then design ERD diagram based on the requirements analysis considering the below hypothetical case:

‘When a new vehicle is to be built, the responsible division places an order with the purchasing officer for the specific set of parts. The purchasing officer will check the available stock of the parts and if necessary arrange for additional supplies from the suppliers registered with NGA. NGA's purchasing department is interested in creating a database to keep a track of data relating to divisions, parts, orders, and suppliers with an aim to manage the process of procuring and delivering materials efficiently. They have sought your help in setting up the database system to record and use relevant data of importance in meaningful ways'.

You may like to consider different hypothetical business rules for designing the ERD and establish a rational behind this.

You need to follow the below structure for the report:

1. Introduction:
2. Rational for the project
3. About the company
4. Business Requirement and operation
5. Conceptual discussion: Information requirement analysis, web platform, e-commerce site
6. ERD Description
7. Conclusion.