- When designing a database, why is it not preferable to store all data in one single table? Why is it better to have multiple separate tables? Give an example of the type of data that would be stored in its own table.
- In the REA framework, a database designer should create a ………………. for each entity.
- a) Record
- b) Table
- c) Secondary key
- d) all of these
- An example of a transitive dependency in a database is:
- Student – grade.
- Telephone area code – phone number.
- Airline – flight number.
- Parking code – parking fine.
- If a company wants to ensure that purchases are for inventory items that are already in their database, it should use which relation property?
- a) Enforce entity integrity
- b) Enforce referential integrity
- c) Query
- d) An outer join
- Susan Hart, the manager of a children’s boutique, collects data from her monthly records of sales, costs, and cash flow. In this case, Susan is making use of _____ databases.
- internal
- external
- historical
- secondary
Order an Essay Now & Get These Homework Help Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
