Design and develop a relational database

Assignment Help Database Management System
Reference no: EM13979437


You are now expected to design, create and populate the relational database for the London Car Rental System as specified in Assignment - Systems Requirement Elicitation.

Design and develop a relational database for a specified user need

You are required to produce a structured database design for the LCR system that will represent a blue-print/documentation for the system.

Your design should include:

1. The use of data modelling techniques that specifically details (P2.1, P3.1):
a. the ER analysis (schema) for the system
b. Data Dictionary
c. Entity Relationship Diagram
d. Normalisation- Create a table in word showing you have normalised your data to the 3rd normal form and evidence this by displaying the data at each stage in a table (UNF, 1NF, 2NF, 3NF)
e. User Interface

2. Using the above Entity Relationship Diagram, design and developa fully functional (third-party)database system for the LCR system. You must show a table in design view with annotations, explaining what all the data elements (rows) are for. The developed system must containing 5 - 7 inter-relational tables including user interface (P3.2).

3. To evaluate the effectiveness of the database solution and suggest methods of improvement, you must provide screenshotsfor the developed database systemand evidence this by producing documentations which must include the following (P3.3):

a. a print out of the ERD in Access
b. a screenshot of the tables created
c. a screenshot of at least two meaningful queries generated from the database
d. a screenshot of at least one report generated from the database
e. a screenshot of a Switchboard (also referred to as Main Menu)
f. several user interface screens/forms
g. suggest possible methods of improvement to any of the above database solutions

4. To finish off produce the following supporting documentation (P3.4):
a. User documentation in form of user manual
b. Technical documentation in the form of in-line technical descriptions

5. You must also produce a report which attempts to discuss the following concepts: (P2.2)
• Entity Relationship Diagram
• Normalisation

6. To express an understanding of databases and database management systems (DBMS) within organisation environments, you are now required to analyse key issues of databases as well as critically evaluate the features and advantages of database management systems.

In evidence, answer the following (P1.1, P1.2):
a. Compare and contrast the integrated database environment with the traditional file processing environment
b. What is a DBMS and why is its application or use in a database system environment very important?
c. Write short notes to describe the components of a database system environment
d. Describe briefly the functions of a DBMS
e. With named examples, describe the ANSI/SPARC Architecture
f. Critically evaluate the types of DBMS Architecture

Reference no: EM13979437

Access - forms and reports

Access - Forms and Reports In this assignment you will learn how to create forms and reports to access and analyze your data. Forms are useful for data entry and navigation. R

Define basic entity relationship diagram colleges

E-R diagram - Basic Entity Relationship Diagram Colleges and universities must draw a clear connection between the requirements of the field for which the student is being pre

Write name of employee on every project located in houston

Write the name(s) of employee(s) who works(work) on every project located in Houston. Write the name(s) of employee(s) who only works(work) on every project located in 'Housto

Discuss considerations for implementing an database system

Discuss the considerations for implementing an operating and database system. Recommend the optimum system, considering the types of revenue and expense transactions for thi

Design a normalized relational database management system

Design a completely Normalized Relational Database Management System that meets both the high-level and technical requirements of the web-based project management system.

Find maximum salary of employees from database table

Find the maximum salary of all employees who are not managers. Give all the managers in the database a 10 percent salary raise. Give all the other employees a 5 percent salar

Techniques to store and retrieve data using an sql database

Develop an understanding of strengths and limitations of various data storage, retrieval methods and models. The assessment requires students to conduct a survey and report

Analysis of a simple case study

VSS has an existing software package that controls its high bay systems and wants to rewrite it. The existing system is written in C and uses C-ISAM files to store data.


Write a Review

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!

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