Design and develop a relational database

Assignment Help Database Management System
Reference no: EM13979437

ASSIGNMENT - DESIGNING & DEVELOPING THE DATABASE

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

Questions Cloud

What is the electric field at a point in the cavity : What is the electric field at a point in the cavity, a distance r = 1.50 cm from the center? What is the electric potential at r = 5.00 cm from the center? Find the potential at r = 1.50 cm from the center.
Describe possible approaches to a systems development effort : Describe possible approaches to a systems development effort and the advantages and disadvantages of each approach.
Calculate the payback period-internal rate of return : Construct a spreadsheet to calculate the payback period, internal rate of return, modified internal rate of return, and net present value of the proposal.
What must change in order for falling object to change speed : Most importantly, what must change in order for the falling object to change its speed? Is it the distance to the centre of the planet? If you pull the earth away from the object as the object falls, will the object slow down or will it keep acce..
Design and develop a relational database : You are required to produce a structured database design for the LCR system that will represent a blue-print/documentation for the system and create and populate the relational database for the London Car Rental System as specified in Assignment - ..
Problem regarding the parent point of view : (A) Is the proposed project, as given, worthwhile from the project point of view? (B) Is the proposed project, as given, worthwhile from the parent's point of view?
Find magnitude of the impulse exerted by the clay on cart : Suppose the cart has mass m = 348 g, and it strikes the clay at speed vo = 1.77 m/s and comes to a dead stop. Assume the track is frictionless, and the clay is crushed inward by 2.04 cm. Find the magnitude of the impulse exerted by the clay on the ..
Describe key tasks that should be included in a project plan : List and describe key tasks that should be included in a project plan. Consider phases in the development process as well as support tasks that are needed for implementation and maintenance.
Debt management policies of companies : Evaluate the debt management policies of these companies, Pepsi and Coke, by analyzing the debt utilization ratios over the most recent years , including:

Reviews

Write a Review

 

Database Management System Questions & Answers

  Define er diagram and database implementation

Development of an ER Diagram and Database Implementation- Course Objectives: This assessment task focuses on the following course objective -ITECH1006

  Create scripts of sql statements

Create scripts of SQL statements

  Explain what project management is and how evolved over time

Explain what project management is, and how it evolved over time

  How do these change with variation in the condence values

Looking at the predictive accuracy (Percent correct) results for tree learning on these data sets, has learning improved accuracy over the baseline ?

  If each instance for r listed above is legal what can you

If each instance for R listed above is legal, what can you say about the FD A → B?

  Write problems and issues related with internet databases

Write down some of problems and issues related with internet databases? Consider security, performance, architecture issues.

  Write a create table statement for the department table

Write a CREATE TABLE statement for the EMPLOYEE TABLE.  Email is required and is an alternate key, and the default value of Department is Human Resources.  Cascade updates but not deletions from DEPARTMENT to EMPLOYEE.

  Find out the advanatges of the data mining to the

the development of complex algorithms that can mine mounds of data that have been collected from people and digital

  Write required sql statements to query the database

Analyse and comprehend a given ER diagram and Relational Data Structures - implement a database based on the given ER diagram and Relational Data Structures;

  Metropolis toys metropolis toys is an independent

metropolis toys metropolis toys is an independent family-owned manufacturer of wooden toys. the toys are designed by

  Write problems and issues associated with internet databases

Over 70% of web applications use database to store persistent data. Write some of the problems and issues associated with internet databases?

  In online marketing a shopping cart is a piece of

in online marketing a shopping cart is a piece of e-commerce software on a web server that allows visitors to an

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