poop
CIS 331 – Database Management Using SQL
Week 2 Homework - Due: Week 3
Name __Scott Merryfield__________________
1. Review Questions - pages 57-58 (A Guide to MySQL – Chapter 2) Questions 1 – 15 (type out the answers)
2. Review Questions - page 87 (A Guide to MySQL – Chapter 3) Questions 1 – 13 (type out the answers)
3. Premier Products - pages 87-88 (A Guide to MySQL – Chapter 3) Exercises 1 – 6 (create in MySQL)
After completing these exercises, use the DESCRIBE command to display each table’s contents. Use the SELECT command to view the data in the tables. You can then use Copy and Paste techniques with either NotePad or Word which will enable you to create printouts of your work.
4. Henry Books - page 88 (A Guide to MySQL – Chapter 3) Exercises 1 – 7 (create in MySQL)
After completing these exercises, use the DESCRIBE command to display each table’s contents. Use the SELECT command to view the data in the tables. You can then use Copy and Paste techniques with either NotePad or Word which will enable you to create printouts of your work.
Estimated Completion Time: ___________ Comments: _______________________________
Lab Assignment Grade: ___________
Verified by Instructor: ___________
Staple this page to all of your homework, all homework for week 2 must be turned in at the same time.
Page 57 Review Questions
1. An entity is a noun describing a person, place or thing and is used for deciding what tables are created based on the entities present.
2. An attribute is a property that applies to a given entity. There can be many attributes for an entity.
3. A relationship is a group of related tables that share a common attribute. A one-to-many relationship is when there is one entity table that relates to many entities table, but not vice-a- versa.
4. A
Week 2 Homework - Due: Week 3
Name __Scott Merryfield__________________
1. Review Questions - pages 57-58 (A Guide to MySQL – Chapter 2) Questions 1 – 15 (type out the answers)
2. Review Questions - page 87 (A Guide to MySQL – Chapter 3) Questions 1 – 13 (type out the answers)
3. Premier Products - pages 87-88 (A Guide to MySQL – Chapter 3) Exercises 1 – 6 (create in MySQL)
After completing these exercises, use the DESCRIBE command to display each table’s contents. Use the SELECT command to view the data in the tables. You can then use Copy and Paste techniques with either NotePad or Word which will enable you to create printouts of your work.
4. Henry Books - page 88 (A Guide to MySQL – Chapter 3) Exercises 1 – 7 (create in MySQL)
After completing these exercises, use the DESCRIBE command to display each table’s contents. Use the SELECT command to view the data in the tables. You can then use Copy and Paste techniques with either NotePad or Word which will enable you to create printouts of your work.
Estimated Completion Time: ___________ Comments: _______________________________
Lab Assignment Grade: ___________
Verified by Instructor: ___________
Staple this page to all of your homework, all homework for week 2 must be turned in at the same time.
Page 57 Review Questions
1. An entity is a noun describing a person, place or thing and is used for deciding what tables are created based on the entities present.
2. An attribute is a property that applies to a given entity. There can be many attributes for an entity.
3. A relationship is a group of related tables that share a common attribute. A one-to-many relationship is when there is one entity table that relates to many entities table, but not vice-a- versa.
4. A