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.
|
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..
|