Create a new database

Assignment Help Database Management System
Reference no: EM131306592

Question - Databases

Use database software such as Microsoft Access or LibreOffice Base to perform the following actions. (Refer to Workshops 9 & 10 for help.)

A. Create a new database. Add tables based on the design of your entity-relationship diagram from Question 1. Make sure that you:· have the correct primary keys for each table,· add foreign keys,· choose appropriate data types for each field.Paste a screenshot of each table in the 'Design View' into your Assignment Answers document.[5 points]

B. Establish relationships between the tables. Enforce referential integrity and cascade updates&deletes.Paste a screenshot of the relationships into your Assignment Answers document.[1.5 points]

C. Fill all tables with some data of your choice. You should have at least 3 records per table.(Pay attention that each entry in a foreign key field has a corresponding entry in the primary key field of the related table. If you choose data that resembles a real scenario, then you should not have any issues.)Paste a screenshot of each table in the MS Access 'Datasheet View' (LibreOffice Base 'DataView') into your Assignment Answers document.[1 point]

D. Think again about the situation that a customer tells you that he/she changed her name because he/she got married.·In order to update the customer's name, how many tables and how many records would you have to change?Explain your answer by writing it in your Assignment Answers document.[1 point]

E. Create a query that shows for each area how many rides were completed where the kilometers driven exceed a certain distance. Make sure you choose a suitable distance based on your data so that you receive some results. Note that there is no direct relationship between the ride table and the area table. You needto address this in your query design. (Think about it and you will find the solution.)Paste a screenshot of the query design and the query result into your Assignment Answers document.[1.5 points]

ALSO, attach the saved file of the software used.

Reference no: EM131306592

What is a cross join and give an example of its syntax

What is a CROSS JOIN? Give an example of its syntax. What three join types are included in the OUTER JOIN classification? What is a correlated subquery? Give an example. What

What are the major components of a migration plan

Discuss why testing is so essential to the development of a new system, and explain how a test case relates to a test plan - compare and contrast unit testing, integration tes

Systems administrator for your school

Using the Web, identify the chief information officer, chief information security officer, and systems administrator for your school. Which of these individuals represents t

Create a small database to include customer numbers

Create a small database to include customer numbers, customer names and customer areas. Place eight records in the database.For the customer area field,use the designations

Count how many employees have blue eyes and are married.

Write the SQL to answer this question: which employees have the same letter starting their first name as their last name (every employee actually meets this criteria, but pr

Explain the security mechanisms available for a database

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check

Create a list of three paramter field values and append it

Create a list of the three paramter field values and append it to the db list. The search must be case insensitive. If the user enters a string that differs only in case then

Build an er diagram for the given tables

The rooms are cleaned by Maids. The IT should keep track of the Maids and whichcleaned what room and when. Maids get paid by check based on the number of rooms each cleaned

Reviews

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