Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Create an Entity Relationship Diagram (ERD) of the normalized version of this table using Visio's crows-foot notation. The ERD should show the PK and FK columns, plus all of the appropriate column attributes (column name, data type/size, null/not null) plus the relationships (with minimum and maximum cardinality) between tables. Requirements: Show the results of the normalization as individual tables Show the FK and PK columns using Visio's notation You must solve the multi-column issue with grades (Hint: This will require a new column) Show the 3-part column definition as noted Show min/max cardinality

Create an Entity Relationship Diagram (ERD) of the normalized version of this table using Visio's crows-foot notation. The ERD should show the PK and FK columns, plus all of the appropriate column attributes (column name, data type/size, null/not null) plus the relationships (with minimum and maximum cardinality) between tables. Requirements: Show the results of the normalization as individual tables Show the FK and PK columns using Visio's notation You must solve the multi-column issue with grades (Hint: This will require a new column) Show the 3-part column definition as noted Show min/max cardinality

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Create an Entity Relationship Diagram (ERD) of the normalized version of this table using Visio's crows-foot notation. The ERD should show the PK and FK columns, plus all of the appropriate column attributes (column name, data type/size, null/not null) plus the relationships (with minimum and maximum cardinality) between tables.

Requirements:

  • Show the results of the normalization as individual tables
  • Show the FK and PK columns using Visio's notation
  • You must solve the multi-column issue with grades (Hint: This will require a new column)
  • Show the 3-part column definition as noted
  • Show min/max cardinality

 

Tables are attached 

Student (StudentID, FirstName, LastName, PrimaryMajor) StudentID FirstName LastName PrimaryMajor 8888 Charles 9999 Joe 1234 John 7777 Arthur 3333 William 5555 Richard 6666 Carroll 2222 Tony 3456 David Albright Ball Smith Bishop МАТН ВА CIS CJ Bonin CIS Chase CJ Cole CIS Costa CIS Carpenter BA Professor (ProfessorlD, ProfName, Profoffice, ProfPhone) ProfessorID ProfName ProfOffice ProfPhone 12 Gray FH323Q 42 Smith FH323R 555-1234 13 Smith FH318H 555-1212 14 Jones Catalog (CourselD, Description, CreditHours, PreReq) Description Web Site Development and Design Database Theory and Practice Structured Query Language System Analysis and Design CreditHours PreReq CourselD CIS3315 CIS4301 12 Hours 3 CIS4301 3 CIS333X CIS4352 CIS3365
Transcribed Image Text:Student (StudentID, FirstName, LastName, PrimaryMajor) StudentID FirstName LastName PrimaryMajor 8888 Charles 9999 Joe 1234 John 7777 Arthur 3333 William 5555 Richard 6666 Carroll 2222 Tony 3456 David Albright Ball Smith Bishop МАТН ВА CIS CJ Bonin CIS Chase CJ Cole CIS Costa CIS Carpenter BA Professor (ProfessorlD, ProfName, Profoffice, ProfPhone) ProfessorID ProfName ProfOffice ProfPhone 12 Gray FH323Q 42 Smith FH323R 555-1234 13 Smith FH318H 555-1212 14 Jones Catalog (CourselD, Description, CreditHours, PreReq) Description Web Site Development and Design Database Theory and Practice Structured Query Language System Analysis and Design CreditHours PreReq CourselD CIS3315 CIS4301 12 Hours 3 CIS4301 3 CIS333X CIS4352 CIS3365
Schedule (CourselD, Section, Semester, ClassType, RoomNo, Days, StartTime, ProfessorID) Semester ClassType RoomNo Days StartTime ProfessorID 202001 Face2Face FH307 202001 Online 202001 Face2Face FH308 202006 Online 202006 Face2Face FH207 202006 Face2Face FH207 202008 Online 202008 Face2Face FH207 202008 Face2Face FH207 202008 Face2Face FH407 CourselD Section CIS3315 110 MW 14:00 12 CIS4301 110 12 CIS4352 110 MW 16:30 12 CIS3365 110 42 CIS4352 110 TR 14:00 13 CIS4352 120 MW 14:00 12 CIS3315 110 12 CIS3315 120 TR 16:30 13 CIS3315 130 MW 19:30 13 CIS4301 110 MW 19:30 14 Grades (CourselD, Semester, Section, StudentiD, Quiz1Grade, Quiz2Grade, Quiz3Grade) StudentID Quiz1Grade Quiz2Grade Quiz3Grade CourselD Semester 202001 202001 Section CIS3315 110 8888 77 81 97 CIS3315 110 9999 78 96 78 CIS4301 202001 110 1234 82 95 75 CIS4352 202001 110 1234 95 88 80 CIS3365 202006 110 1234 89 82 77 CIS4352 202006 110 7777 90 93 85 CIS4352 202006 120 3333 78 CIS3315 202008 110 1234 72 78 77 CIS3315 202008 120 5555 73 90 CIS3315 202008 130 6666 81 74 CIS3315 202008 130 2222 97 78 CIS4301 202008 110 1234 45 70 73 CIS4301 202008 110 3456 69 82 83
Transcribed Image Text:Schedule (CourselD, Section, Semester, ClassType, RoomNo, Days, StartTime, ProfessorID) Semester ClassType RoomNo Days StartTime ProfessorID 202001 Face2Face FH307 202001 Online 202001 Face2Face FH308 202006 Online 202006 Face2Face FH207 202006 Face2Face FH207 202008 Online 202008 Face2Face FH207 202008 Face2Face FH207 202008 Face2Face FH407 CourselD Section CIS3315 110 MW 14:00 12 CIS4301 110 12 CIS4352 110 MW 16:30 12 CIS3365 110 42 CIS4352 110 TR 14:00 13 CIS4352 120 MW 14:00 12 CIS3315 110 12 CIS3315 120 TR 16:30 13 CIS3315 130 MW 19:30 13 CIS4301 110 MW 19:30 14 Grades (CourselD, Semester, Section, StudentiD, Quiz1Grade, Quiz2Grade, Quiz3Grade) StudentID Quiz1Grade Quiz2Grade Quiz3Grade CourselD Semester 202001 202001 Section CIS3315 110 8888 77 81 97 CIS3315 110 9999 78 96 78 CIS4301 202001 110 1234 82 95 75 CIS4352 202001 110 1234 95 88 80 CIS3365 202006 110 1234 89 82 77 CIS4352 202006 110 7777 90 93 85 CIS4352 202006 120 3333 78 CIS3315 202008 110 1234 72 78 77 CIS3315 202008 120 5555 73 90 CIS3315 202008 130 6666 81 74 CIS3315 202008 130 2222 97 78 CIS4301 202008 110 1234 45 70 73 CIS4301 202008 110 3456 69 82 83
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS