Ch. 5 questions

Question 1

What is the purpose of a database

Answer 1

to keep track of things. lists of data involving a single theme can be stored in a spreadsheet. lists that involve data with multiple themes require a database

Question 2

What is a database?

Answer 2

self describing collection of integrated records, database is a collection of tables plus relationships among the rows in those tables, plus special data, called metadatam that describes the structure of the database

Databases that carry their fata in the form of tables and represent relationhsips using foregn keys are called relational databases

Question 3

What are the components of a database application system?

Answer 3

applications make database data more aceessible and useful

1. database security
2. creating the database and its structure
3. proessing the database
4. administering the database

Question 4

How do databasae applications make databases more useful?

Answer 4

it is a collection of forms, reports, queries, and application programs that process a database.
Data entry forms are used to read, insert modify, and delete data. reports show data in a structured context

Question 5

How are data models used for database development?

Answer 5

through user involvement, data models are created based on what data is necessary for the users to perform their jobs. ideally it would contain just the data that they need.
data models describe the data and relationships that will be stored in the database.
Do not allow the database developers to create something in the data model that is not part of your business world

Question 6

How is a data model transformed into a database design?

Answer 6

database design team transforms entitites into tables and expresses relationships by defining foreign keys.
consists of normalizing (getting rid of duplicate info)

Question 7

Q8: 2022?

Answer 7

k