Test Your Knowledge About Relational Database Fundamentals

Microsoft Enterprise Consortium Microsoft Enterprise Consortium Microsoft Enterprise Consortium Database Fundamentals Test Your Knowledge 1 Prepared by Jennifer Kreie, New Mexico State University Hosted by the University of Arkansas

Microsoft Enterprise Consortium Microsoft Enterprise Consortium Test what you know about relational database fundamentals This presentation has questions to test what you understand about relational databases the models and the construction. The answers are not provided. If you re not certain about your answers, review the presentations about database fundamentals. 2 Prepared by Jennifer Kreie, New Mexico State University Hosted by the University of Arkansas

Microsoft Enterprise Consortium Microsoft Enterprise Consortium A few questions 1. What is the data model term that has this definition? A person, place, thing, or event about which we need to keep information. ______________ 2. What is a field called if it is used to link to a primary key field in another table? ______________ 3. A field (or fields) that uniquely identifies each row in a table is called a(n) ____________ ? 3 Prepared by Jennifer Kreie, New Mexico State University Hosted by the University of Arkansas

Microsoft Enterprise Consortium Microsoft Enterprise Consortium A few more questions 4. If a relationship in the data model has a maximum cardinality of one on one end and crows feet on the other end, what type of relationship is this? _____-____-______ 5. Which of the following could be a primary key for the EMPLOYEE table? a. First Name + Last Name b. Phone Number c. Job Title d. Social Security Number e. Birth Date 4 Prepared by Jennifer Kreie, New Mexico State University Hosted by the University of Arkansas

Microsoft Enterprise Consortium Microsoft Enterprise Consortium A few more questions 6. E. F. Codd proposed the principles for __________ databases, which is the type of database most widely used today. 7. An attribute that might have more than one value for each entity _________, is called a __________ attribute. 5 Prepared by Jennifer Kreie, New Mexico State University Hosted by the University of Arkansas

Microsoft Enterprise Consortium Microsoft Enterprise Consortium Test your understanding of data models and databases. Now, you ll see some data models and answer questions about them. You don t have to know the business setting in order to read these models; just interpret what the data model depicts. 6 Prepared by Jennifer Kreie, New Mexico State University Hosted by the University of Arkansas

Microsoft Enterprise Consortium Microsoft Enterprise Consortium Test your understanding of data models and databases. 8. In the data model shown, how many tables would you build in the database? in for CUSTOMER ORDER INVENTORY has of 7 Prepared by Jennifer Kreie, New Mexico State University Hosted by the University of Arkansas

Microsoft Enterprise Consortium Microsoft Enterprise Consortium Test your understanding of data models and databases. 9. Which of these would get a foreign key? Check all that apply. CUSTOMER ORDER INVENTORY None would. All would. in for CUSTOMER ORDER INVENTORY has of 8 Prepared by Jennifer Kreie, New Mexico State University Hosted by the University of Arkansas

Microsoft Enterprise Consortium Microsoft Enterprise Consortium Test your understanding of data models and databases. 10.In the data model shown, how many tables would you build in the database? EMPLOYEE ASSIGNMENT PROJECT 9 Prepared by Jennifer Kreie, New Mexico State University Hosted by the University of Arkansas

Microsoft Enterprise Consortium Microsoft Enterprise Consortium Test your understanding of data models and databases. 11.Which of these would get a foreign key? Check all that apply. EMPLOYEE ASSIGNMENT PROJECT None would. All would. EMPLOYEE ASSIGNMENT PROJECT 10 Prepared by Jennifer Kreie, New Mexico State University Hosted by the University of Arkansas

Microsoft Enterprise Consortium Microsoft Enterprise Consortium Test your understanding of data models and databases. 12.In the data model shown, how many tables would you build in the database? VENDOR PART BILL OF MATERIALS BOM_ID BOM_Title VendID VendName {Phone} PartID PartDesc 11 Prepared by Jennifer Kreie, New Mexico State University Hosted by the University of Arkansas

Microsoft Enterprise Consortium Microsoft Enterprise Consortium Test your understanding of data models and databases. 13.In the data model shown below, which of these would get a foreign key? Check all that apply. VENDOR PART BILL OF MATERIALS None would. All would. VENDOR PART BILL OF MATERIALS 12 Prepared by Jennifer Kreie, New Mexico State University Hosted by the University of Arkansas

Microsoft Enterprise Consortium Microsoft Enterprise Consortium How did you do? If you couldn t answer all these questions, you should review the database fundamentals videos. It is very helpful to understand these concepts and terms when you work with databases. 13 Prepared by Jennifer Kreie, New Mexico State University Hosted by the University of Arkansas

Microsoft Enterprise Consortium Microsoft Enterprise Consortium Resources Microsoft Enterprise Consortium: http://enterprise.waltoncollege.uark.edu/mec.asp Microsoft Faculty Connection Faculty Resource Center http://www.facultyresourcecenter.com/ 14 Prepared by Jennifer Kreie, New Mexico State University Hosted by the University of Arkansas