Question from 11-17

1 0 , ..d 15% 10:51 AM Assignment 1 - Chapter 2-2- Saved view Questions 1-17 Dutabase Design Fundiea Key Te rupeaning group pinay key quality hrd nomal form sbasedesige functionaly dtemne suple unnomalined selation nonkay col Review Questions What is an eny? What in a relational dalabase 7. Descibe the shorthand represertation of the strucure of a seitional detsbo his ichnique by napresenting the datsbas for Colonial Adventure Toursa Fures 1-4 haugh 1-8 in Chapter 1 t How do you quaity the name of a feld, and when do you need to do is? a What does it mean for a column to be functionaly dependent on another oolumn s a panary key? What is fhe primary key lor each of the tables in the Colonial Adventure Tours desbase shown in Chopar 1? & For a depament store its numbat and mame numbat to which the advisor is assigned t. A diesbese at a college must support t the tolowing sequinaments b For an adviaor, sonp his or her number,t nome, first mame, and the depertmant & coursa, store its code and description (for eample, MTH110. Algebra d For a student, store hia or her number, first name, and last name. For each couse ha studant seas, store the course code, course description, and prade eamed Ais, store the rumber and name of the studaits acdvisor. Assurme thet an aovisor right advise any number of students but that aach student asalt one advisor Fur Dssign the databass for the preceding set of requiremenrts. Use your own expe fans as student to determine ay turetional apenieces Lst he tables, co. unns, and selatorehipa In addton, nepreeent your desin with in E-R dagram Chapter 2 12. Define first normal form. 13. Define second normal form. What types of problems might you encounter using that are not in second normal form? tables 14. Define third normal form. What types of problems might you encounter you encounter using tables that are not in third normal form? Using the functional dependencies you determined in Question 11, convert the following table to an equivalent collection of tables that are in third 15. normal form. STUDENT STUDENT NUM, STUDENT LAST NAME , STUDENT FIRST NAME ADVISOR LAST NAME,ADVISOR PIRST NAME, (COURSE CODE DESCRIPTION, GRADE) u would need to make to your answer for Question 11 if the require- 16. List the changes yo ments 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 ina me ments change so that you must store the year and the semester in which a student took a course and received a grade