poop

Topics: SQL, Relational model, Database normalization Pages: 18 (796 words) Published: September 20, 2014
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 repeating group is a poor database design where there are multiple pieces of data in a cell designed for only one. 5. A relationship is the association between two entities.

6. A database containing entities that have a relationship to other entities within the database. 7. Shorthand representation of a database is simply a way to design a database without have to physically create it first. Similar to pseudo coding in programming.

branch (BRANCH_NUM, BRANCH_NAME, BRANCH_LOCATION,
NUM_EMPLOYEES)
publisher (PUBLISHER_CODE, PUBLISHER_NAME, CITY)
author (AUTHOR_NUM, AUTHOR_LAST, AUTHOR_FIRST)
book (BOOK_CODE, TITLE, PUBLISHER_CODE, TYPE, PRICE, PAPERBACK) wrote (BOOK_CODE, AUTHOR_NUM, SEQUENCE)
inventory (BOOK_CODE, BRANCH_NUM, ON_HAND)

8. To qualify a field, you simply name the field with the addition of the table name and a period before the field name. This is necessary when there are multiple instances of the same field name within different entities so that there is less confusion. 9. Functionally dependant is a term that means that a value of one column is based upon the value of another column. 10. A primary key is a unique identifier used for the entity that in which it is contained.

branchPK BRANCH_NUM
publisherPK PUBLISHER_CODE
author PKAUTHOR_NUM
bookPKBOOK_CODE
wrotePKBOOK_CODE
inventoryPKBOOK_CODE

11. DEPT_NUM DEPT_NAME
ADV_NUM ADV_FIRSTNAME, ADV_LASTNAME, DEPT_NUM
CRS_CODE CRS_NAME, CRS_DESCRIPTION
STD_NUMSTD_FIRSTNAME, STD_LASTNAME, STD.CRS_CODE,
STD_GRADE, ADV_NUM

DEPARTMENT (DEPT_NUM, DEPT_NAME)
ADVISOR (ADV_NUM, ADV_FIRSTNAME, ADV_LASTNAME, DEPT_NUM)
COURSE(CRS_CODE, CRS_NAME, CRS_DESCRIPTION)
STUDENT(STD_NUM, STD_FIRSTNAME, STD_LASTNAME,
STD.CRS_CODE, STD_GRADE, ADV_NUM)

12. A relationship table that can not contain repeating groups on a single row. 13. A form where data anomalies are eliminated by separating tables where data exists that is not...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • poop Essay
  • Poop Essay
  • poop Essay
  • Poop Research Paper
  • Poop Essay
  • Poops Essay
  • Poop Essay
  • Poop Research Paper

Become a StudyMode Member

Sign Up - It's Free