Question: Draw an ERD containing the Student, DegreePlan and Faculty entity types connected by 1:M relationships from Student to DegreePlan and Faculty to DegreePlan. A student

Draw an ERD containing the Student, DegreePlan and Faculty entity types connected by 1:M relationships from Student to DegreePlan and Faculty to DegreePlan. A student submits a degree plan for approval to a faculty adviser. Both a student and a faculty are required for a degree plan. For the student entity type, add attributes StdNo, StdFirstName, StdLastName, StdStreet, StdCity, StdState, StdZip, and StdAdmitSems. For the Faculty entity type, add FacNo, FacLastName, FacFirstName, and FacRank. For the DegreePlan entity type, add attributes DPNo, DPRevDate, and DPComments. Include a Course entity type and a M:N relationship (Enrolls) connecting Course and DegreePlan. A degree plan must have at least one associated course. For the Course entity type, add attributes for CrsNo, CrsTitle, and CrsUnits. For the Enrolls relationship, add attributes EnrSems, EnrYear, and EnrGrade. Also add a Milestone entity type and an M:N relationship (Achieves) connecting Milestone and DegreePlan. A degree plan must have at least one milestone. For the Milestone entity type, add attributes MSNo, MSName, MSDeadline, and MSDesc. For the Achieves relationship, you should record AchDateSubmitted, AchDateApproved, and AchResult.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

answer the following questions. 1. Analyze The Pub's competitive environment and macroenvironment. 2. Answer the following questions. a. What are the two most significant driving forces of change in...

1. Draw an ERD containing the Order and Customer entity types connected by a 1-M relationship from Customer to Order. Choose an appropriate relationship name using your common knowledge of...

Draw ERD diagram Crows foot notation #1 Draw an ERD containing the Order and Customer entity types connected by a 1:M relationship between Customer and Order. Choose an appropriate relationship name...

1. Draw an ERD containing the Orde r and Customer entity types connected by a 1-M relationship from Customer to Order . Choose an appropriate relationship name using your common knowledge of...

5. Draw an ERD containing the Employee and Appointment entity types connected by an M-N relationship. Choose an appropriate relationship name using your common knowledge of interactions between...

Draw ERD diagram Crows foot notation #2 Draw an ERD containing the Patient, Physician, and Visit entity types. A patient can see multiple physicians but only one physician on any one given visit....

Create the ERD in your drawing tool for microsoft visio for the following problem; Augment your ERD from problem 31--> [31. Draw an ERD containing the Lab, LabVisit, and Patient entity types...

Python code (normal Python and not pyspark) to answer the following question. "Social computing research at the University of Minnesota" has released moving rating data sets at different sizes at the...

An investor purchased the following 5 bonds. Each bond had a par value of $1,000 and an 8% yield to maturity on the purchase day. Immediately after the investor purchased them, interest rates fell...

A Crummey power provides for which one of the following?A ) Creates a gift of a present interestB ) Results in a taxable event for the beneficiaryC ) Creates a gift of a future interestD ) Allows the...

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....