Assignment Task: Data base system for the SmartMovers Transport Company
Part 1: The submission is in the form of an individual written report. This should be written in a concise, formal business style using single spacing and font size 12. You are required to make use of headings, paragraphs and subsections as appropriate, and all work must be supported with research and referenced using the Harvard referencing system. Please also provide a bibliography using the Harvard referencing system. The recommended word limit is 2,000-2,500 words, although you will not be penalized for exceeding the total word limit.
Part 2: The submission is in the form of a fully functional relational database system demonstrated to the Tutor; and an individual written report (please see details in Part 1 above).
Part 3: The submission is in the form of a witness statement of the testing completed by the Tutor; technical documentation; and a written report (please see details in Part 1 above).
Course Learning Outcomes:
A) Use an appropriate design tool to design a relational database system for a substantial problem.
B) Develop a fully functional relational database system, based on an existing system design.
C) Test the system against user and system requirements.
D) Produce technical and user documentation.
Assignment Brief:
Activity 1:
Activity1.1:
a. Identify the user and system requirements to design a database for the above scenario.
b. Identify entities and attributes of the given scenario and design a relational database system using conceptual design (ER Model)by including identifiers (primary Key) of entities and cardinalities, participations of relationships.
c. Convert the ER Model into logical database design using relational database model including primary keys foreign keys and referential Integrities. It should contain at least five interrelated tables.
Activity 1.2:
a. Explain data normalization with examples. Check whether the provided logical design in task 1.1 is normalised. If not, normalize the database by removing the anomalies.
b. Design set of simple interfaces to input and output for the above scenario using Wireframe or any interface-designing tool.
c. Explain the validation mechanisms to validate data in the tables with examples.
Activity 1.3
a. Check whether the given design (ERD and Logical design)is representing the identified user and system requirements to access the effectiveness of the design.
Activity 2:
Activity 2.1
Develop the database system with evidence of user interface, output and data validations, and querying across multiple tables.
a. Develop a relational database system according to the ER diagram you have created (Use SQL DDL statements).
b. Provide evidence of the use of a suitable IDE to create a simple interface to insert, update and delete data in the database
c. Implement the validation methods explained in task 1.2-part c.
d. Display the details payment with the job details and the customer details using Join queries
Activity 2.2:
a. Explain the usage of DML with below mentioned queries by giving at least one single example per each case from the developed database.
Select
Update
Delete
Activity 2.3:
a. Explain how security mechanisms have been used and the importance of these mechanisms for the security of the database. Implement proper security mechanisms (EX: -User groups, access permissions) in the developed database.
Activity 2.4:
a. Explain the usage of the below SQL statements with the examples from the developed database
- Group by
- Order by
- Having
- Between
- Where
Activity 3:
Activity 3.1
a. Provide a suitable test plan to test the system against user and system requirements
b. Provide relevant test cases for the database you have implemented
Note:- Learner needs to give expected results in a tabular format and screenshots of the actual results with the conclusion
Activity 3.2
a. Explain how the selected test datain task 3.1 b)can be used improve the effectiveness of testing.
Activity 3.3
a. Get independent feedback on your database solution from the non-technical users and some developers (use surveys, questioners, interviews or any other feedback collecting method) and make recommendations and suggestions for improvements in a separate conclusion/recommendations section.
Activity 4
Activity 4.1:
a. Prepare a simple users' guide and a technical documentation for the support and maintenance of the software.
Activity 4.2:
a. Your technical documentation should include some of the UML diagrams (Use case diagram Class diagram, etc.), flow charts for the important functionalities, context level DFD and the Level 1 DFD
Activity 4.3:
a. Suggest the future improvements that may be required to ensure the continued effectiveness of the database system.
For all the students studying this course in their academic curriculum, who are not capable to compose their own assignment paper, we come up with the Database Design and Development Assignment Help service, in order to eradicate all your academic problems with ease.
Tags: Database Design and Development Assignment Help, Database Design and Development Homework Help, Database Design and Development Coursework, Database Design and Development Solved Assignments
Attachment:- Database Design and Development.rar