In infоrmаtiоn theоry, bаndwidth refers to which of the following?
Yоu cаn аnswer аll questiоns in this exam.Please dо not use Word Document - Type all answers in this exam. Questions 1. A local flower shop wants to setup their database. They are trying to keep track of the following: their customers - customer ID, first name, last name, phone and email. They also want to keep track of the customers' order information such as the order ID, order date, total amount. They want to also keep track of which flowers are ordered: flower ID, name and type. You can add additional information or details if you wish. (Yes, this is the same scenario as the midterm - think of what you created.)1.1 In the space below, type all of the data that needs to be kept track of for the scenario above in a 1NF (Flat File) table. Make sure you explain if the table you created is in 1NF or not? (5 points) 1.2 Use the normalization technique and form the 3NF tables. Make sure to explain the normalization steps you followed in each normal form, that is what did you do to transform 1NF to 2NF and then 2NF to 3NF. (20 points). 1.3 In the space below, type out the Create Table command in SQL for creating the database you have designed, make sure to use the right DATATYPES, CONSTRAINTS, and CONSTRAINT REFERENCES. (25 points) Create Table ##### ( ); 1.4 In the space below, type one SQL Insert into Values ( ); command for each table in your database. (20 points) ______________________________________________________________________________________________________________________________________ 2. A Parks and Recreation department organizes a variety of activities throughout the year - like fitness classes, art workshops, sports leagues, and community events. They need a centralized database to manage activities, track participants registrations, and coordinate staff. You can add additional information or details if you wish. (Yes, this is the same scenario as the midterm - think of what you created.) 2.1 In the space below, type all of the data that needs to be kept track of for the scenario above in a 1NF (Flat File) table. (5 points) 2.2 Use the normalization technique and form the 3NF tables. Make sure to explain the normalization steps you followed in each normal form, that is what did you do to transform 1NF to 2NF and then 2NF to 3NF. (20 points). 2.3 In the space below or on the Word document, type out the Create Table command in SQL for creating the database you have designed, make sure to use the right DATATYPES, CONSTRAINTS, and CONSTRAINT REFERENCES. (25 points) Create Table ##### ( ); 2.4 In the space below or on the Word document, type one SQL Insert into Values ( ); command for each table in your database. (20 points) ______________________________________________________________________________________________________________________________________ 3. A hair salon wants you to set up their database. They want to keep track of their customers (you can decide on what information to keep track of for the customers). They want to keep track of their stylists (you can decide what information to keep track of for the stylists). They want to keep track of the schedule between the customers and the stylists. (Payment information is not needed). (Yes, this is the same scenario as the midterm - think of what you created.) 3.1 In the space below, type all of the data that needs to be kept track of for the scenario above in a 1NF (Flat File) table. (5 points) 3.2 In this scenarion, you can scribble of your scratch paper and just show the 3NF tables without explaining the normalization process. Make sure to explain the normalization steps you followed in each normal form. (20 points). 3.3 In the space below or on the Word document, type out the Create Table command in SQL for creating the database you have designed, make sure to use the right DATATYPES, CONSTRAINTS, and CONSTRAINT REFERENCES. (25 points) Create Table ##### ( ); 3.4 In the space below or on the Word document, type one SQL Insert into Values ( ); command for each table in your database. (20 points) ______________________________________________________________________________________________________________________________________ __________________________________________________________________________ For Questions 4 – 11: Write response on the Word document. Please refer to the 2 tables below (UNIV_STUDENT, UNIV_DORM) UNIV_STUDENT Student_ID First_Name Last_Name Dorm_Name 100 Smith Terry Stephens 200 Johnson Jeff Alexander 300 Abernathy Susan Horan 400 Smith Susan Alexander 500 Wilcox John Stephens 600 Webber Carl Horan 700 Simon Carol Stephens 800 Smith Jay Stephens UNIV_DORM DormName DormCost Alexander 3,800 Horan 4,000 Stephens 3,500 Walters 5,000 ________________________________________________________________ Make sure you use the attributes name as provided in the tables above, otherwise the grade may be impacted. 4. (5 points) Write the SQL Query to list all students in the first table. 5. (5 points) Write the SQL Query to select all students who have an “S” as the fourth character in their last name. Use a wildcard. 6. (5 points) Write the SQL Query to list student first name, last name and dorm name where dorm cost is either 3,500.00, 4,000.00, or 5,000.00. 7. (5 points) Write the SQL Query to show the maximum cost dorms change, minimum cost dorms may charge, and the average cost of the dorms. 8. (5 points) Write the SQL Query to show student first name, last name, dorm name where the dorm has more than 2 students in it. 9. (5 points) Write the SQL Query to show what is the difference between the highest and lowest dorm cost? 10. (5 points) Write the SQL Query to first and last name of students who pay less than the average dorm cost. 11. (5 points) Write the SQL Query to show the dorm with the maximum number of students.
"I understаnd thаt this is а clоsed-bооk test and will uphold academic standards."