1. Physical design refers to:
i. developing a database model that will support company operations.
ii. purchasing your hardware components.
iii. selecting the specific hardware characteristics based on data storage and data access requirements.
iv. the process of converting your ERD into tables and defining your rows and columns based your entities and attributes.
2. Database design refers to:
i. developing a database model that will support company operations.
ii. focusing on understanding the business and its functional areas or business processes.
iii. selecting the specific hardware characteristics based on data storage and data access requirements.
iv. the process of converting your ERD into tables, and defining your rows and columns based your entities and attributes.
3. A one-to-many relationship is :
i. a relationship that guarantees that a record is unique.
ii. an association between a record and its fields. used to describe attributes.
iii. when a row in one table is matched to multiple rows in a second table and a row in the second table is matched back to a row in the first table.