What are advantages of storing data in a dbms like access

Assignment Help Database Management System

Reference no: EM131250983

Question 1:

Some people like to store their information in Excel files. What are the advantages of storing data in a database management system like Access over Excel? Name 3.

Question 2:

In Access, we can implement "cascading deletes" when specifying how tables relate to each other. When a record is deleted from a master table (the table on the "one" side of the relationships), what happens to related records in the other tables to which the master table has one-to-many relationships with "cascading deletes" specified?

Question 3:

In our University database, why is your student number considered a primary key in the student table, but a foreign key in other tables?

Question 4:

What are 3 advantages of using Excel in conjunction with Access when working with a database?

Question 5:

When dealing with databases that are shared among many people, we store the data in a central location and utilize a "front end" to present the data to each user. How does using a "front end" decrease network traffic, improve user response time, and make updates more efficient?

Reference no: EM131250983

Questions Cloud

Calculate total current assets and total current liabilities : The trial balance for K and J Nursery, Inc., listed the following account balances at December 31, 2016, the end of its fiscal year: cash, $27,000; accounts receivable, $22,000; inventories, $36,000; Calculate total current assets and total current ..

Write a paragraph in which analyze the extended metaphor : Write a paragraph in which analyze the extended metaphor

After thorough survey of audio system markets : Bell Company, a manufacturer of audio systems, started its production in October 2014. For the preceding 3 years, Bell had been a retailer of audio systems. Assuming that Bell manufactures, on average, 1,500 audio systems per month, enter each cost i..

What is special about the game of chicken : What is the difference between a dominant strategy and a dominated strategy? Why would a player in a game be unlikely to choose a dominated strategy?

What are advantages of storing data in a dbms like access : Some people like to store their information in Excel files. What are the advantages of storing data in a database management system like Access over Excel? Name 3.

Write memo in which you communicate a negative message : Write a 1- to 2-page formal letter or memo in which you communicate a negative message. You may select from one of the following scenarios: Tell your investors or employees about a recent decrease in your company's stock value

Required reserve-deposit ratio for demand deposit : Suppose the required reserve-deposit ratio for demand deposit (rd) is greater than that of saving and time deposits (rt). Let k be the cash to total deposits ratio; t be ratio of saving and time deposits to total deposits; and e be the excess rese..

Difference between a pure strategy and a mixed strategy : 1. Can a game have a Nash equilibrium even though neither player has a dominant strategy? Can a game have a Nash equilibrium even though neither player has a dominated strategy? 6. What is the difference between a pure strategy and a mixed strateg..

How to increase profits and customer retention : (ESPU 200) - Use your dictionary to check spellings, and check your writing carefully for mistakes before you hand it in. Write at least 200 words and

User Account

All Pages