This assignment is designing a complete database management system to address a practical database need and implement
Question:
This assignment is designing a complete database management system to address a practical database need and implement a relational database based on that design. Your database system should be designed to perform general information management tasks such as systematic collection, update, and retrieval of information for a small organization. The objective of Assignment #1 is to develop a normalized relational data model describing the primary business processes of VCPP University. The initial entities for your model are STUDENT, COURSE, and INSTRUCTOR. In addition to these initial entities, you are provided with several business rules.
Initial Entities.
STUDENT ( StudentID, StudentName, StudentAddress, StudentPhone, StudentEmail, StudentDOB, StudentMajor, GPA)
COURSE (CourseID, CourseName, CreditHours,)
INSTRUCTOR( InstructorID, InstructorName, InstructorAddress, InstructorPhone, InstructorEmail, Salary)
Deliverable 3
Contains the same information as Deliverable 2, except in a different format. Deliverable 3 is an Entity Relationship Diagram (ERD) that you develop in ERwin. All of the functionality indicated in the business rules must be present. Also, this exercise is an excellent opportunity to show your understanding of Enhanced Entity Relationship Diagrams (EERD), as you will have the opportunity to demonstrate Supertype/Subtypes. A helpful hint here is to take a screenshot of your ERwin ERD instead of printing it. ERwin places a big watermark description across the page when you print using the free Community Edition of the software; however, if you simply take a screenshot, then the watermark does not appear. All entities, attributes, and relationships must be properly labeled. Although they are presented in different visual formats, the information contained on this Deliverable 3 ERwin logical data model (ERD) must exactly correspond to the information contained on Logical Schema of the deliverable.
*Deliverable 3 will contain the same information as Deliverable 2 but it will be in a different format. Deliverable 3 will be in the format of an ERD, and you will develop your ERD in ERwin.