Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you just please draw the chen model no need to create the database ! Thanks! (IT'S AT THE BOTTOM) Project Three-Part 1- Northwoods University
Can you just please draw the chen model no need to create the database ! Thanks! (IT'S AT THE BOTTOM)
Project Three-Part 1- Northwoods University Design - The Northwoods University Student Registration Database Northwoods University has decided to replace its aging mainframe-based student registration system with a more modern client/server database system. School officials want students to be able to retrieve course availability information, register for courses, and print transcripts using personal computers located in the student computer labs. In addition, faculty members must be able to retrieve student course lists, drop and add students, and record course grades. Faculty members must also be able to view records for the students they advise. Security is prime concern, so student and course records must be protected by password access. The data items for the Northwoods database are: Student name, address, telephone number, class (freshman, sophomore, junior, or senior), date of birth, PIN (personal identification number), and advisor Course call number (such as COM340), course name, credits, location, duration, maximum enrollment, instructor, and term offered Instructor name, office location, telephone number, rank (Professor, Instructor, etc.), and PIN Student enrollment and grade information. The database must be able to allow multiple sections of the same course to be taught by different instructors and on different days and times. You have been asked to design a relational database to support the required tasks. You will provide three diagrams for this project. An Entity Relationship Diagram (ERD) using the Chen model (this will be considered a more detailed conceptual diagram, showing each table that will exist and how they relate)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started