Nt2520 Unit 3 Assignment 1
Unit 3 Assignment 1: Homework
Learning Objectives and Outcomes
Use the database modeling template in MS Visio.
Create entities and add attributes of a database.
Define relationship between entities of a database.
Create many-to-many relationships with a linking table.
Assignment Requirements
Answer the following True or False questions on the student answer sheet.
Required Resources
Textbook
Submission Requirements
Submit your written answers to your instructor at the beginning of Unit 4.
Unit 3 True/False Questions
Indicate whether the following statements are true or false on the student answer sheet.
1) The logical design is independent of any database management system.
2) The physical design is the logical design adapted to the constraints and features of the database management system.
3) You should always try to create cross relationships between parent and tables.
4) Naming conventions help support clarity and consistency in database design.
5) One to one relationships between entities are valid but rare.
6) Crow’s feet notation conveys more information about cardinality than arrow notation.
7) In a one-to-many relationship, each row on in the primary key table can be related to any number of rows in the foreign key or child table.
8) Cross relationships between parent and child tables can make data entry impossible.
9) Maximum cardinality refers to the maximum number of records allowed in a table.
10) Minimum cardinality is the smallest number of records allowed in a related table.
11) A linking entity is an entity that is used to resolve a many to many relationship into two one too many relationships.
12) A weak entity is dependent on another entity for its meaning.
13) The following diagram is an example of a one-to-one relationship.
14) The following diagram is an example of a many-to-many relationship.
15) Many-to-many
Learning Objectives and Outcomes
Use the database modeling template in MS Visio.
Create entities and add attributes of a database.
Define relationship between entities of a database.
Create many-to-many relationships with a linking table.
Assignment Requirements
Answer the following True or False questions on the student answer sheet.
Required Resources
Textbook
Submission Requirements
Submit your written answers to your instructor at the beginning of Unit 4.
Unit 3 True/False Questions
Indicate whether the following statements are true or false on the student answer sheet.
1) The logical design is independent of any database management system.
2) The physical design is the logical design adapted to the constraints and features of the database management system.
3) You should always try to create cross relationships between parent and tables.
4) Naming conventions help support clarity and consistency in database design.
5) One to one relationships between entities are valid but rare.
6) Crow’s feet notation conveys more information about cardinality than arrow notation.
7) In a one-to-many relationship, each row on in the primary key table can be related to any number of rows in the foreign key or child table.
8) Cross relationships between parent and child tables can make data entry impossible.
9) Maximum cardinality refers to the maximum number of records allowed in a table.
10) Minimum cardinality is the smallest number of records allowed in a related table.
11) A linking entity is an entity that is used to resolve a many to many relationship into two one too many relationships.
12) A weak entity is dependent on another entity for its meaning.
13) The following diagram is an example of a one-to-one relationship.
14) The following diagram is an example of a many-to-many relationship.
15) Many-to-many