1 to 17 please

Databese Design Fundamentals Review Questions 1. What is an entity? 2. What is an attribute? 3. What is a relationship? What is a one-to-many relationship? 4. What is a repeating group? 5. What is a relation? 6. What is a relational database? 7. Describe the shorthand representation of the structure of a relational database. Iliustrate this technique by representing the database for Colonial Adventure Tours as shown in Figures 1-4 through 1-8 in Chapter 1. 8. How do you qualify the name of a field, and when do you need to do this? 9. What does it mean for a column to be functionally dependent on another column? 10. What is a primary key? What is the primary key for each of the tables in the Coloniai Adventure Tours database shown in Chapter 1 ? 11. A database at a college must support the following requirements: a. For a department, store its number and name. b. For an advisor, store his or her number, last name, first name, and the department number to which the advisor is assigned. c. For a course, store its code and description (tor example, MTH110, Algebra). d. For a student, store his or her number, first name, and last name. For each course the student takes, store the course code, course description, and grade earned. Also, store the number and name of the student's advisor. Assume that an advisor might advise any number of students but that each student has just one advisor. Design the database for the preceding set of requirements. Use your own experience as a student to determine any functional dependencies. List the tables, columns, and relationships. In addition, represent your design with an EP diagram. 12. Dofine first normal form. 13. Define second normal form. What types of problems might you encounter using tables that are not in second normal form? 14. Define third normal form. What types of problerns might you encounter using tables that are not in third normal form? 15. Using the functional dependencies you determined in Question 11, convert the following table to an equivalent collection of tables that are in third normal form. STUDENT (STUPENT_NUM, STUDENT_LAST_NAME, STUDENT_FIRST__LAME, ADVISOR_NUM, ADVISOR_LAST_NAME, ADVISOR_FIRST_HUME, (COURSE_CODE, DESCRIPTION, GRADE) ) 16. List the changes you would need to make to your answer for Question 11 if the requirements change so that a student can have more than one advisor. 17. List the changes you would need to make to your answer for Question 11 if the requirements change so that you must store the year and the semester in which a student took a course and received a grade