1. Using this Lunch Room Data Report, answer the questions that follow. Date Student Sales 12/02/2003...

Transcribed Image Text:

1. Using this Lunch Room Data Report, answer the questions that follow. Date Student Sales 12/02/2003 497 12/03/2003 440 12/04/2003 447 12/05/2003 442 12/06/2003 330 Faculty/Staff Hamburger/Taco Pizza Bar Sales 23 19 30 27 12 Bar 335 285 301 325 229 122 126 126 107 83 Soup/Salad Bar 63 48 50 37 30 a. What does this report mean? b. What data was collected? c. What information does this table provide from the data collected? d. How do you think this information is used by those reading the report? e. Generate at least two conclusions based on the data provided. f. Generate at least two questions that you would ask about the data provided. 2. Write down the steps of a simple credit-card transaction. How many places does the information go, and what happens if the transaction is not complete at any one of the steps? What role does a database play in this process? 3. For each entity, select the attribute that could be the unique identifier of each entity. Entity: STUDENT Attributes: student ID, first name, last name, address Entity: MOVIE Attributes: title, date released, producer, director Entity: LOCKER Attributes: size, location, number 4. Read the given business scenario and walk through the steps below. "I'm the owner of a small movie rental store. We have over 3,000 movies that we need to keep track of. "Each of our movies has a DVD or VHS tape number. For each movie, we need to know its title and category (e.g., comedy, suspense, drama, action, war, or sci-fi). "Yes, we do have multiple copies of many of our movies. "We give each movie a specific ID, and then track which DVD or VHS contains the movie. A movie can be either DVD or VHS format. "We always have at least one DVD or VHS tape for each movie we track, and each DVD or VHS tape is always a copy of a single, specific movie. "Our DVDs and VHS tapes are very long. We don't have any movies that require multiple DVDs or VHS tapes." a. Write a list of nouns used in the scenario. b. Name each entity. c. Is each instance of the entity uniquely identifiable? Which attribute or attributes could serve as the unique attribute to identify the entity? 5. Identify the vocabulary word for each definition below. A relational database chart that is used to map the information from the entity relationship diagram the unique identifier for each row of data Links data in one table to the data in a second table by referring to the PK column in the second table Indicates if a column must contain a value Indicates if the value in the column is unique within the table Refers to the format and definition of the data in each column 1. Using this Lunch Room Data Report, answer the questions that follow. Date Student Sales 12/02/2003 497 12/03/2003 440 12/04/2003 447 12/05/2003 442 12/06/2003 330 Faculty/Staff Hamburger/Taco Pizza Bar Sales 23 19 30 27 12 Bar 335 285 301 325 229 122 126 126 107 83 Soup/Salad Bar 63 48 50 37 30 a. What does this report mean? b. What data was collected? c. What information does this table provide from the data collected? d. How do you think this information is used by those reading the report? e. Generate at least two conclusions based on the data provided. f. Generate at least two questions that you would ask about the data provided. 2. Write down the steps of a simple credit-card transaction. How many places does the information go, and what happens if the transaction is not complete at any one of the steps? What role does a database play in this process? 3. For each entity, select the attribute that could be the unique identifier of each entity. Entity: STUDENT Attributes: student ID, first name, last name, address Entity: MOVIE Attributes: title, date released, producer, director Entity: LOCKER Attributes: size, location, number 4. Read the given business scenario and walk through the steps below. "I'm the owner of a small movie rental store. We have over 3,000 movies that we need to keep track of. "Each of our movies has a DVD or VHS tape number. For each movie, we need to know its title and category (e.g., comedy, suspense, drama, action, war, or sci-fi). "Yes, we do have multiple copies of many of our movies. "We give each movie a specific ID, and then track which DVD or VHS contains the movie. A movie can be either DVD or VHS format. "We always have at least one DVD or VHS tape for each movie we track, and each DVD or VHS tape is always a copy of a single, specific movie. "Our DVDs and VHS tapes are very long. We don't have any movies that require multiple DVDs or VHS tapes." a. Write a list of nouns used in the scenario. b. Name each entity. c. Is each instance of the entity uniquely identifiable? Which attribute or attributes could serve as the unique attribute to identify the entity? 5. Identify the vocabulary word for each definition below. A relational database chart that is used to map the information from the entity relationship diagram the unique identifier for each row of data Links data in one table to the data in a second table by referring to the PK column in the second table Indicates if a column must contain a value Indicates if the value in the column is unique within the table Refers to the format and definition of the data in each column