User Account

All Pages

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

Questions Cloud

Hedge portfolio earns the risk-free rate over both periods : Consider a two-period, two-state world. Let the current stock price be 45 and the risk-free rate be 5 percent. Each period the stock price can go either up by 10 percent or down by 10 percent. A call option expiring at the end of the second period ha..
How you would implement a three lines of defense model : A case analysis either describing how the three lines of defense model is currently being used in a publicly traded company, or how you would implement a three lines of defense model within your organization.
Maximize cash management efficiency : If a firm's suppliers stop offering discounts, what effect would this have on accounts receivable from customers? What is the effect if a firm does not take trade discounts? What are some steps that you can take to maximize cash management efficiency..
Type of financial institution : Which of the following is not a type of financial institution? Which of the following is not able to be written off as an itemized deduction on your taxes?
Create a new database : 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 scr..
How much will kyle have in five years to put down on his car : Kyle has $1,000 in cash received for high school graduation gifts from various relatives.- How much will Kyle have in five years to put down on his car?
What amount will be in the account in 20 years : Luis wants to know how much he will have available to spend on his trip to Belize in three years if he deposits $3,000 today at an interest rate of 9%.
How is that different from excavating modern day cemeteries : Read "Battle of the Bones" Do archaeologists have the right to excavate Native American ancestors? How is that different from excavating modern day cemeteries? Is there a difference?
What is the amount of casualty loss : Reynaldo and Sonya, a married couple, had flood damage in their home due to a faulty water heater during 2015, which totally ruined the furniture that was stored in their garage. What is the amount of casualty loss that Reynaldo and Sonya can claim o..

Reviews

Write a Review

Database Management System Questions & Answers

  Triangle classification specification

Consider the triangle classification specification. The system reads in three positive values from the standard input. The three values A,B, and C are interpreted as representing the lengths of the sides of a triangle.

  Create a pl-sql procedure to print out the reservation

Write a PL/SQL function that given a reservation ID, returns the name of guest who made that reservation. If there is no such reservation in the database, return null. Please call this function with input reservation ID 1, and print out the return..

  Need a system that networks its 3 campuses in the us and

need a system that networks its 3 campuses in the us and one campus in singapore. transaction data for all campuses

  Create the erd containing all primary keys, foreign keys

A tiny college wants to keep track of the history of all administrative appointments (date of appointment and date of termination) (hint: time variant data are at work)

  Write methods for outlier detection

Exceptions in credit card transactions can aid us fraudulent use of credit card. Suggest two methods for outlier detection.

  Evaluate requirements and select appropriate parameters

Advanced Database Administration (COMP 0343) Manage client-server connections using RDBMS Net Services - Evaluate requirements and select appropriate parameters to ensure effective storage management in a database system.

  Determine airports with late flights to toronto-database

Determine airports with late flights to Toronto on a big plane. "Late" means departing after 9:00pm; "big" means with capacity 150 passengers or more

  Most spreadsheet software like that shown in the

most spreadsheet software like that shown in the accompanying figure includes a kind of analysis tool where users can

  Create a database named ctsdb studentid

Create a text file named Create_ StudentID .sql (for example, Create_3087654.sql) that will contain SQL statements to: Create a database named CTSDB StudentID.

  Draw an entity-relationship diagram for this database

Draw an Entity-Relationship diagram for this database using UML notation. Be sure to include all the entities mentioned above, together with attributes (including primary key attributes), relationships and multiplicity constraints

  Write a vba code to extract the data

Create a form (frmUpdateMedia), write a VBA code to extract the data and display it in a listbox, dropdownbox or any from of grid. Integrate the spreadsheet data into the application.

  What is a foreign key constraint

Examples of non-candidate keys include the following: {name}, {age}. (Note that {gpa} can not be declared as a non-candidate key from this evidence alone even though common sense tells us that clearly more than one student could have the same grade p..

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