Answered step by step
Verified Expert Solution
Link Copied!

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)image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions