Homework Help is Here – Start Your Trial Now!
Engineering
Data Structures and Algorithms
Please answer these 5 multiple choice questione by looking at this ERD diagram below. Thank you in advance. 1. Customer is: A. An attribute B. An entity. C. A relationship D. A query 2. Match one of these to store_ID and one of these fo Customer_ID -An entity in Customer - A composite key in Customer -A foreign key in Customer - A composite attribute in Customer - A primary key in Customer . 3. A FOREIGN KEY is a field (or collection of fields) in one table, that refers to the PRIMARY KEY in another table. The table with the foreign key is called the child table and the table with the primary key is called the referenced or parent table True oe False? 4. First Name in Customer is a good candidate for primary key True False? 5. The relationship Store to Customer from the ERD is A. One to many , non-identifying , mandatory on one side optional on the other B. One to many, identifying,mandatory on one side optional on the other C. One to many, non- identifying, mandatory on both sides. D. One to many, identifying mandatory on both sides

Please answer these 5 multiple choice questione by looking at this ERD diagram below. Thank you in advance. 1. Customer is: A. An attribute B. An entity. C. A relationship D. A query 2. Match one of these to store_ID and one of these fo Customer_ID -An entity in Customer - A composite key in Customer -A foreign key in Customer - A composite attribute in Customer - A primary key in Customer . 3. A FOREIGN KEY is a field (or collection of fields) in one table, that refers to the PRIMARY KEY in another table. The table with the foreign key is called the child table and the table with the primary key is called the referenced or parent table True oe False? 4. First Name in Customer is a good candidate for primary key True False? 5. The relationship Store to Customer from the ERD is A. One to many , non-identifying , mandatory on one side optional on the other B. One to many, identifying,mandatory on one side optional on the other C. One to many, non- identifying, mandatory on both sides. D. One to many, identifying mandatory on both sides

icon
Related questions
Question
Please answer these 5 multiple choice questione by looking at this ERD diagram below. Thank you in advance. 1. Customer is: A. An attribute B. An entity. C. A relationship D. A query 2. Match one of these to store_ID and one of these fo Customer_ID -An entity in Customer - A composite key in Customer -A foreign key in Customer - A composite attribute in Customer - A primary key in Customer . 3. A FOREIGN KEY is a field (or collection of fields) in one table, that refers to the PRIMARY KEY in another table. The table with the foreign key is called the child table and the table with the primary key is called the referenced or parent table True oe False? 4. First Name in Customer is a good candidate for primary key True False? 5. The relationship Store to Customer from the ERD is A. One to many , non-identifying , mandatory on one side optional on the other B. One to many, identifying,mandatory on one side optional on the other C. One to many, non- identifying, mandatory on both sides. D. One to many, identifying mandatory on both sides
customer customer_id SMALLINT store_id TINY INT first_name VARCHAR(45) last_name VARCHAR(45) email VARCHAR(50) 4 more... Indexes 7 store store_id TINY INT #manager_staff_id TINYINT 2 more... Indexes
Transcribed Image Text:customer customer_id SMALLINT store_id TINY INT first_name VARCHAR(45) last_name VARCHAR(45) email VARCHAR(50) 4 more... Indexes 7 store store_id TINY INT #manager_staff_id TINYINT 2 more... Indexes
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer