1) Identify the main components of an ERD. a) Table, Column, Row b) Database, Schema, Data c) Field, Query, Report d) Entity, Attribute, Relationship 2) Determine the function of a Primary Key (PK). a) Stores data types b) Links entities together c) Identifies all attributes d) Uniquely identifies each record 3) Select the correct relationship type. a) One-to-One b) One-to-Many c) Many-to-Many d) Many-to-One 4) Identify the purpose of a Foreign Key (FK). a) To create a backup b) To link records between two tables c) To display records d) To generate random values 5) Determine the option that is NOT an attribute. a) Name b) Phone Number c) Email d) Student 6) Choose the correct action when a Many-to-Many relationship exists. a) Combine the entities b) Relationship cardinality c) SQL queries d) Table indexes 7) Select the option that best represents an entity. a) Date of Birth b) Student c) Email Address d) Phone Number 8) Identify the scenario that best represents a One-to-Many (1:M) relationship. a) A book is borrowed by only one student b) One lecturer teaches many subjects c) Many students use one computer d) One printer prints only one document 9) Determine the component that connects two entities in an ERD. a) Attribute b) Data Type c) Relationship d) Field

Leaderboard

Visual style

Options

Switch template

Continue editing: ?