QUESTION 16 8-4 question 1 Create an ERD based on the following Summit Sporting Goods scenario. Be sure to follow drawing conventions for readability and clarity "I'm a manager of a sporting-goods wholesale company that operates worldwide to fill orders from retail sporting-goods stores. The stores are our customers (some of our people prefer to call them our clients). Right now we have 15 customers worldwide, but we're trying to expand our customer base by about 10% each year starting this year. Our two biggest customers are Big John's Sports Emporium in San Francisco and Woman sports in Seattle. For each customer, we must track an ID and a name. We may track an address (including the city, state, zip code, and country) and phone number. We maintain warehouses in different regions to best fill the order of our customers. For each order, we must track an ID. We may track the date ordered, date shipped, and payment type when the information is available." QUESTION 17 Identify the appropriate match for the integrity rules below. A. Entity integrity rule A column must contain only values consistent with the defined data format of the column B. Column-integrity rule Define the relationally correct state for a data-base; they ensure that users can perform only those operations that leave the database in a correct, consistent state C. Referential integrity rule D. User-defined integrity rule , A primary key must be unique and no part of the primary key can be null E. Data-integrity rule A foreign key must match an existing primary key value (or else be null) The data stored in a database must comply with the rules of the database QUESTION 18 9-1 Question 2 Data Integrity in the DJs Database Examine the sample data for these tables in the DJs on Demand database. Check for enti-ty, referential, and column integrity. Identify any data-integrity violations. Assume that all date columns should have a date format and all amount (cost) columns should have a number format. Primary key refers to CLIENTS first_name last_name phone_num email 100 Antonio Peters 555-1801 apeters@yahoo.com 45 Mary Collins 662-2275 Sarika Patel 383-4572 sari@patel.com 19 Ivan Balazs 777-5511 ibalazs@aol.com Primary key Foreign Key Foreign Key EVENTS id name date description cost client_id theme_code Peter's 22-Apr 800.00 100 BB graduation Collins 12-Mar Cocktail hour 2gs 45 TROP wedding followed by dinner Collins Day Garden party 400.00 TROP rehearsal before dinner wedding Eks Club 01-May Black-tie affair 1200.00 77 SIXT annual fundraiser 15 45 50 refers to Primary key THEMES code description CARN Carnival SIXT Sixties TROP Tropical QUESTION 21 9-2 Question 3 Identify and match the table diagram notations listed below. - Primary key Foreign key Unique key Mandatory D. "pk" . Optional E. "O" QUESTION 22 9-2 Question 5 Identify and match the answer that best suite each of the table names below 1997 classes A. ame cannot contain spaces or special characters . Schedule_of_classes_spring_2003 B. Name is more than 30 characters long Financial Aid deadlines! C. Can't start with numbers: must start with a letter QUESTION 16 8-4 question 1 Create an ERD based on the following Summit Sporting Goods scenario. Be sure to follow drawing conventions for readability and clarity "I'm a manager of a sporting-goods wholesale company that operates worldwide to fill orders from retail sporting-goods stores. The stores are our customers (some of our people prefer to call them our clients). Right now we have 15 customers worldwide, but we're trying to expand our customer base by about 10% each year starting this year. Our two biggest customers are Big John's Sports Emporium in San Francisco and Woman sports in Seattle. For each customer, we must track an ID and a name. We may track an address (including the city, state, zip code, and country) and phone number. We maintain warehouses in different regions to best fill the order of our customers. For each order, we must track an ID. We may track the date ordered, date shipped, and payment type when the information is available." QUESTION 17 Identify the appropriate match for the integrity rules below. A. Entity integrity rule A column must contain only values consistent with the defined data format of the column B. Column-integrity rule Define the relationally correct state for a data-base; they ensure that users can perform only those operations that leave the database in a correct, consistent state C. Referential integrity rule D. User-defined integrity rule , A primary key must be unique and no part of the primary key can be null E. Data-integrity rule A foreign key must match an existing primary key value (or else be null) The data stored in a database must comply with the rules of the database QUESTION 18 9-1 Question 2 Data Integrity in the DJs Database Examine the sample data for these tables in the DJs on Demand database. Check for enti-ty, referential, and column integrity. Identify any data-integrity violations. Assume that all date columns should have a date format and all amount (cost) columns should have a number format. Primary key refers to CLIENTS first_name last_name phone_num email 100 Antonio Peters 555-1801 apeters@yahoo.com 45 Mary Collins 662-2275 Sarika Patel 383-4572 sari@patel.com 19 Ivan Balazs 777-5511 ibalazs@aol.com Primary key Foreign Key Foreign Key EVENTS id name date description cost client_id theme_code Peter's 22-Apr 800.00 100 BB graduation Collins 12-Mar Cocktail hour 2gs 45 TROP wedding followed by dinner Collins Day Garden party 400.00 TROP rehearsal before dinner wedding Eks Club 01-May Black-tie affair 1200.00 77 SIXT annual fundraiser 15 45 50 refers to Primary key THEMES code description CARN Carnival SIXT Sixties TROP Tropical QUESTION 21 9-2 Question 3 Identify and match the table diagram notations listed below. - Primary key Foreign key Unique key Mandatory D. "pk" . Optional E. "O" QUESTION 22 9-2 Question 5 Identify and match the answer that best suite each of the table names below 1997 classes A. ame cannot contain spaces or special characters . Schedule_of_classes_spring_2003 B. Name is more than 30 characters long Financial Aid deadlines! C. Can't start with numbers: must start with a letter