User Account

All Pages

Unit 04 Database Design and Development Assignment

Assignment Help Database Management System
Reference no: EM132448846

Unit 04 Database Design and Development - Pearson Higher Nationals in Computing

Assignment - 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 penalised 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).

Learning Outcomes:

LO1 Use an appropriate design tool to design a relational database system for a substantial problem.
LO2 Develop a fully functional relational database system, based on an existing system design.
LO3 Test the system against user and system requirements.
LO4 Produce technical and user documentation.

Assignment Brief

Activity 01

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 scenarioand 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 interfacesto input and output for the above scenario using Wireframe or any interface-designing tool.
c. Explain the validation mechanisms to validate data in the tableswith 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.

Attachment:- Database Design and Development.rar

Reference no: EM132448846

Questions Cloud

Determine net income for Year if QualCore had used US GAAP : Determine stockholders' equity at December 31, Year 5, if QualCore had used U.S. GAAP. Determine net income for Year 5 if QualCore had used U.S. GAAP.
How often do abducted children turn out to be runaways : Evaluate the AMBER Alert process. Is this a successful procedure? How often do "abducted" children turn out to be runaways or falsely reported as missing?
Discuss social control theories in brief : In Chapter 7 of the primary text, Siegel (2015) discusses social control theories, specifically Travis Hirschi's social bonding theory (1969).
Describe the four elements of social bonding theory : Travis Hirshi's social bonding theory is a form of social control. While other criminological theories attempt to explain why crime occurs, social bonding.
Unit 04 Database Design and Development Assignment : Unit 04 Database Design and Development Assignment Help and Solution, Pearson Higher Nationals in Computing - Assessment Writing Service
What topic have you selected for the assignment : Address the following in a literature review of 1-2 pages: What topic have you selected for this assignment? Explain. How did you select the topic you are.
What is the amount of current liabilities : The current ratio of a company is 6:1 and its acid-test ratio is 1:1. If inventories and prepaid items amount to $463,000, what is amount of current liabilities
Discuss the US were to adopt a zero income tax model : The primary way in which the IRS would calculate the tax rate in order to ensure that the same level of tax revenue would still be collected.
Discuss how to prevent non-law-enforcement personnel : Discuss how to prevent non-law-enforcement personnel or organizations from influencing the ethics of your criminal justice professionals.

Reviews

len2448846

2/4/2020 2:36:55 AM

Database Design & Development 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).

Write a Review

Database Management System Questions & Answers

  Create a provider database and related reports

Create a provider database and related reports and queries to capture contact information for potential PC componentproviders that might be used to purchase the equipment your specified in your MS Word project - the PC specifications

  Determine functional dependencies of table

Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table.

  Jdbc enables applications to exchange data

JDBC enables ____ applications to exchange data with any database that uses SQL statements and is compliant with the

  Implement direct-address table keys of stored elements

Suggest how to implement direct-address table in which keys of stored elements don't require to be distinct and elements can have satellite data.

  Identify which data components are entities and attributes

Identify which data components are entities and attributes and relationship between each using an object representation diagram through use of graphical tools.

  Provide examples of grains within a data warehouse

Identify the importance of selecting the Grain of a data warehouse in the Kimball Data Warehouse Model. Provide examples of grains within a Data Warehouse.

  What are the major business objectives

What are the major business objectives and processes that the airline company carries out and list the information systems and subsystems that are used to support their portal and describe how they are related to the overall business objectives and..

  Describe a general company security policy for database

Describe a general company security policy for the database "layer" of security only (avoid getting into network security protocols or application level security for this exercise, and assume that there are security mechanisms in place that allow ..

  Develop a table that identifies top threats to new customer

Develop a table that identifies the top threats to the new customer rewards program at Kudler Fine Foods in preparation for your final report. Include the likely vulnerabilities each threat might exploit.

  List and describe three main capabilities or tools of a dbms

List and describe three main capabilities or tools of a DBMS. Describe the effect of cloud computing on traditional IT infrastructure

  Compare a use case description and an activity diagram

Compare a use case description and an activity diagram. Devise a scenario in which you would use a case description, and devise a scenario in which you would.

  Create a small bank account database with one account table

Create a small Bank Account database with one Account table. The Account table Should have fields for account number, customer last and first names, and current balance.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd