here the excel example of data to be used for the pject

Assignment Purpose: You begin reflecting back to the memo you wrote initially and then to the interview questions and answers and the proposal you most recently submitted. At that time, you had only a vague understanding of the business and you did a rough outline in notes of a few tables that you thought would be required for this database design Now that you are reviewing some of the data provided to you that rough sketch needs to become a first-pass diagram of the new database solution. Your initial ideas for tables may or may not still hold in light of the data that you have nov received Task: Your assignment is to submit a Word document or PDF containing all the following 1. A copy of your Draw.io diagram of the database design as you have it thus far. You can simply export your sa .png image file, and then insert that image into your word document. 2. Identify at least three additional questions related to data and structure you would want answered to continue your overall design. With respect to the database design, you must make sure it includes all of the following: 1. This diagram should incorporate everything you know about the company thus far and show as many tables as you believe needed given the information at your disposal to- date. 2. For each table list the attributes (columns) you believe will be required. 3. You will also need to identify the connecting points between tables. We don't need to be concerned with issues of cardinality yet or the types of relationships, just that there will be a relationship of some kind and what the common columns are on both sides of the relationship 4. Finally, you will need to identify the primary key for each table. Enable Editing D B 1 Student Course Schedules (partial lists provided as examples) 2 3 Student 4 Id Student Name Course List 5 6 Data from Client A: 7 101122 Ribers, Charles ENG 362 Victorian Writers; ENG 386 Critical Theory; MTH 2262 Alegebra 1; FRN 1320 French 8 101943 Johnson, Gary Edward BIO 420 Bio Ethics; AHS 219 Art History of the Middle Ages 9 111292 Ferguson, Alicia P. CIS 413 Data Structures; CIS 499 Directed Readings 10 112974 Lang, Daisy M. ENG 412 History of Rhetoric; FMS 429 Feminist Discourse of the 20th and 21 Centuries 11 120506 Rosa, Valentina ACC 273 Managerial Accounting; BUS 153 Marketing for a Global Audience 12 13 Data from Client B: 14 43C1223 Susan Clark CSCI 2999 Capstone Final Project 15 43D0009 Kevin M. Riley Not Registered for Current Semester 16 43XF231 Valance Martinez ELEC 2011 Commercial Wiring: COMM 1153 Business Communications 17 43AB975 Destiny Sanders MATH 2453 Calculus 1; ENVS 1545 Envir ental Science; HUMM 2115 World Religions 18 19 20 21 22 23 24 6 BE Course Schedule List Course Registration List Catalogue Faculty List Faculty Courses A 1 Course Registration (partial lists provided as examples) 2 D E 3 4 Course ID Course Name # of Registered Students 5 Room Number Students Enrolled (Only one Student ID is given in example) 10 25 Macy Hall 319 Douglas Hall 1111 Embridge 2019 Macy Hall 287 44 6 Data from Client A: 7 8 ENG 362 Victorian Writers: 1820-1875 9 ACC 273 Managerial Accounting 10 CIS 413 Data Structures with Java 11 ENG 412 History of Rhetoric from the Greek Sophists to Present 12 13 Data from Client B: 14 CSci 2999 Computer Capstone Final Project 15 COMM 1153 Business Communications 16 MATH 2453 Calculus I 17 HUM2115 World Religions 18 101122,...11 additional Student IDS. 120506, ... 24 additional Student IDs. 111292, ... 43 additional Student IDs. 112974, ... Seven additional Student IDs. 8 28 23 IBT Building, Room 243 43C1223,... 27 additional Student IDS. BAS Building, Room 123 43XF231, ...22 additional Student IDs. Emerson Building, Room 212 43AB975, ... 17 additional Student IDS. BAS Building, Room 247 43AB975, ... 18 additional Student IDS. 18 19 19 20 21 22 23 24 25 126 Catalogue Faculty Courses Faculty List Course Registration List Course Schedule List B 1 Course Catalogue (partial lists provided as examples) D E 2 F G H 3 4 Course ID Course Name 5 Department Credit Hours Fall Winter/Spring Semesters Offered Full Summer 6 Data from Client A: Summer A Summer B 7 Yes 4 Yes Yes Yes Yes 3 Yes 8 ENG 362 Victorian Writers: 1820-1875 English 3 9 ACC 273 Managerial Accounting Business 10 CIS 413 Data Structures with Java Computer Science 4 11 ENG 412 History of Rhetoric from the Greek Sophists to Present English 12 13 Data from Client B: 14 CSCI 2999 Computer Capstone Final Project Information Technology 3 15 COMM 1153 Business Communications Business 3 16 MATH 2453 Calculus Mathematics 5 17 HUM 2115 World Religions Humanities 3 18 19 X xx Fall, Winter 20 21 22 23 24 25 26 Course Schedule List Course Registration List Catalogue Faculty List Faculty Courses 1 Faculty (partial lists provided as examples) D E F G H 12 3 4 Faculty Name 5 Office Phone Race DOB Gender Hire Date Title 6 317-555-8911 317-555-1267 Macy Hall 111 Douglas Hall 052 Douglas Hall 079 Macy Hall 113 African American 9/13/1969 Female 9/15/1991 Professor White Non/Hispanic 10/15/1960 Gender Non-Conforming 8/16/1986 Professor White Non/Hispanic 4/7/1978 Male 1/5/2007 Associate Professor White Non/Hispanic 2/28/1980 Female 6/16/2012 Professional Instructor 463-555-0025 317-555-3843 7 Data from Client A: 8 Chase Donovan 9 Mary Etzge 10 Peter Pasternovich 11 Emily Romanov 112 13 Data from Client B: 14 Anderson Booker 15 Genelle Brown 16 Antoine Davis 17 David McWeiller FAC Building, Room 145 901-555-2728 BAS Building, Room 3212 901-555-6233 Emerson Building, Room 2124 901-555-7101 BAS Building, Room 3214 901-555-3782 African American 7/14/1977 Male Hispanic 3/21/1972 Female African American 4/16/1981 Male White Non/Hispanic 11/4/1975 Male 9/4/2018 Instructor 9/15/2005 Professor 1/7/2006 Associate Professor 5/25/2009 Lecturer 20 27 A B 1 Faculty Courses (partial lists provided as examples) D Course 1 Course 2 Course 3 4 Faculty Name 5 6 Data from Client A: 7 8 Chase Donovan 9 Mary Etzge 10 Peter Pasternovich 11 Emily Romanov ENG 362: Victorian Writers: 1820-1875 ENG 151: Composition | ACC 273: Managerial Accounting ACC 284: Cost Accounting CIS 413: Data Structures with Java CIS 111: Introduction to Programming using Java ENG 412: History of Rhetoric from the Greek Sophists to Present ENG 151: Composition 1 (2 sections) ACC 285: Topics in Finance CIS 251: Java I 13 Data from client B: 14 Anderson Booker 15 Genelle Brown 16 Antoine Davis 17 David McWeiller CSCI 2999: Computer Capstone Final Project COMM 1153: Business Communications MATH 2453: Calculus HUM 2115: World Religions CSCI 2151: Database Theory with SQL Server COMM 1179: Technical Writing MATH 2454: Calculus 2 HUM 2116: The Bible as Literature CSCI 2576: JavaScript Programming COMM 1181: Design for Technical Writers MATH 1163: Advanced Algebra HUM 1386: World Civiliations 8001 so co 20 2011