Week 1 Graded Quiz :Managing Big Data with MySQL (Excel to MySQL: Analytic Techniques for Business Specialization) Answers 2025

Answer Key

1. Relational databases are based on
   ✔ Set theory
   ❌ Matrix algebra, ❌ Probability theory, ❌ Information theory

2. YearsInBusiness in ER diagram is
   ✔ Derived attribute
   ❌ Unique, ❌ Candidate key, ❌ Composite attribute

3. Cardinality constraints Doctor ↔ Outpatient Location
   ✔ A doctor can work at many outpatient locations, but does not have to work at any
   ❌ Other options

4. Unique identification of doctors
   ✔ LicenseNo
   ❌ State, ❌ Either, ❌ Both

5. Doctor_ID and OL_ID are called
   ✔ Primary keys
   ❌ Unique attributes, ❌ Foreign keys, ❌ Composite attributes/keys

6. Most likely information stored in relational DB
   ✔ Metadata (file name, location, creation time)
   ❌ Pictures, ❌ Tweets, ❌ Texts

7. Inference from relational schema
   ✔ A doctor can work at many outpatient locations, and an outpatient location can have many doctors working at it
   ❌ Other options

8. Attributes to identify unique books
   ✔ BookName and BookPubDate
   ❌ BookName only, ❌ BookName + EditorID, ❌ BookName + WriterID

9. True statements about foreign keys
   ✔ Foreign keys allow info in different tables to be linked
   ✔ Foreign keys refer to columns with unique values for every row in other tables
   ❌ Foreign keys always have the same name as primary key
   ❌ Foreign keys have unique values in their own table

10. Tables needed to determine outpatient locations for Karen Smith
    ✔ 2 or 3, depending on strategy
    ❌ 1, ❌ 2, ❌ 3

11. Cardinality constraints Doctor ↔ Outpatient Location (repeat of Q3)
    ✔ An outpatient location must have at least 1 doctor working, can have many doctors
    ❌ Other options

12. Technical terms for relational schema
    ✔ Entities → tables, ✔ Fields → columns, ✔ Tuples → rows

13. Unique identifier for shows
    ✔ ShowDate and ShowVenue
    ❌ Other options

14. Columns to combine transactions and departinfo
    ✔ “sku” → skuinfo, then “deptID” → deptinfo
    ❌ Other options

15. Requirements for efficiency (set theory)
    ✔ Each row represents a unique instance
    ✔ Each column represents a unique category of information
    ✔ Single tables represent smallest logical parts
    ❌ No NULL values required

Summary Table: Relational Databases & ER Diagrams Quiz