Reference no: EM132307917
Database Development Assessment
The purpose of this assignment is to support the following Learning Outcomes (LO) for this topic
LO1 Design and develop a complex database for a given scenario, with a professional approach to the documentation of the system
LO2 Construct SQL programs using advanced to ensure efficient processing
LO3 Detect and evaluate various key issues which affect database systems and their perfor- mance
LO4 Compare and contrast approaches for improving a database's performance
This assessment is to develop a database for the Flinders Automotive Solar Team (FAST). FAST needs an inventory database to manage a wide variety of components and to track which projects use which components. They also need to manage purchases and delivery of purchases. Only team members have permission to access the database and security of their details needs to be ensured.
Requirements so far
When a component is assigned to a project, the In Stock value must be adjusted.
When deliveries come in, the In Stock value must be adjusted and if necessary the component price updated.
The following reports should be generated:
• A list of all components in alphabetical order.
• A list of all components in each category.
• A list of all components in each location.
• A report on all incomplete purchase orders.
• A report on all purchase orders for a specified data range.
• A report showing which components need to be re-ordered.
• A report for a specified project showing all of its components and total expenditure.
• A report on sponsors showing their donations.
It is expected that you will follow the recommendations in the textbook for the different phases of database development, the types of documentation needed, and the level of detail required. In addition, a test plan and strategies should be developed along with the data dictionary
All documentation must be produced using VP-UML.
Fact Finding
A preliminary conceptual design and data dictionary has been supplied. This needs further analysis.
1. Describe the fact-finding techniques you would use to identify the important facts required to develop the database.
2. What is the form used for? What is its purpose?
3. Create an appropriate mission statement for the database system.
4. Create a diagram to represent the scope and boundaries of the database system. 5.What different user roles will have access to the database?
6.What information will each role have permission to access? 7.Define the user views required for each role.
Requirements Collection and Analysis
1. Find out more about the requirements of each user view so that you can define the type of data needed and the processing needed for the data.
2. Document requirements for local data models and a global data model.
3. Document the Users' Requirements Specification for the database and any assumptions (with justification) you have made.
Database Design
At each step of Database design, produce the appropriate documentation.
Conceptual Design
1.Identify entity types
2.Identify relationship types
3.Identify and associate attributes with entity or relationship types
4.Determine attribute domains
5.Determine candidate, primary, and alternate key attributes
6.Use enhanced modelling concepts (optional)
7. Check model for errors and redundancy
8. Validate conceptual model against user transactions
9.Develop draft test plan
10.Review conceptual data model
Logical Design
1. Derive relations for logical data model
2.Validate relations using normalisation
3.Validate relations against user transactions
4.Check integrity constraints
5.Review logical data model
6.Check for future growth
7.Update test plan
Physical Design
1. Translate logical data model for target DBMS
(a) Select target DBMS (usually a user's decision) (b)Design base relations
(c)Design representation of derived data
(d)Design general constraints
2. Design file organisations and indices
(a) Analyse transactions
(b)Select file organisations
(c)Select indices
(d)Estimate disk space requirements
3.Design user views
4. Design security mechanisms
5. Introduce controlled redundancy if necessary
6.Create SQL scripts for data definition
7.Create SQL scripts to populate all tables with test data 8.Create SQL scripts for required queries
9.Monitor and tune the operational system
10.Update test plan
11.Create SQL scripts to test system
12.Test operational system
2 Project Plan
It is suggested that you follow this project plan to ensure that you can complete the whole assignment and get appropriate feedback as you progress.
Section Documentation
|
Week
|
Requirements Specification
|
4
|
Requirements Analysis
Updated Conceptual Design and test plan
|
5
5
|
Logical Design
|
6
|
Physical Design
|
11
|
Attachment:- Database Development.rar