Looking at your data model

1. Write a query(s) that will de-normalize your

data into a combination of Excel Files

Looking at ABOVE data model

1. Write a query(s) that will de-normalize your

data into a combination of Excel Files using SQL SERVER

PK Department Dep_id Dept_name Dept_phone building_hall has Professor KPK pro id p_frame plname pro phone num p_zipcode -teaches has Course PK PK Registration Reg_id Registration_startdate Registration_enddate reg_status Course id Course_Name Course_StartDate Course_EndDate reg_fees student id FK1 FK2 course_id Student PK registers Student id f_name |_name phone_num major PK Department Dep_id Dept_name Dept_phone building_hall has Professor KPK pro id p_frame plname pro phone num p_zipcode -teaches has Course PK PK Registration Reg_id Registration_startdate Registration_enddate reg_status Course id Course_Name Course_StartDate Course_EndDate reg_fees student id FK1 FK2 course_id Student PK registers Student id f_name |_name phone_num major