Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
There is a ERD of a college that has to enroll students to classes in the attached file. Both the ERDs are the same, MySQLWorkbench was used to indicate the relationships in the 2 ERDs respectively. There are sample datasets for the CLASS, STUDENT_CATEGORIES and STUDENT tables. 3) What problem do you detect in the data of the STUDENT table? Why?

There is a ERD of a college that has to enroll students to classes in the attached file. Both the ERDs are the same, MySQLWorkbench was used to indicate the relationships in the 2 ERDs respectively. There are sample datasets for the CLASS, STUDENT_CATEGORIES and STUDENT tables. 3) What problem do you detect in the data of the STUDENT table? Why?

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

There is a ERD of a college that has to enroll students to classes in the attached file. Both the ERDs are the same, MySQLWorkbench was used to indicate the relationships in the 2 ERDs respectively.

There are sample datasets for the CLASS, STUDENT_CATEGORIES and STUDENT tables.

3) What problem do you detect in the data of the STUDENT table? Why? 

 

The ERD focusing on the STUDENT entity ENROLL ENROLL NUM INT ENROLL DATE DATE OSTU NUM INT CLASS NUM INT Indexes STUDENT STU_NUM INT STU_LNAME VARCHAR(45) STU FNAME VARCHAR(45) STUDY STARTDATE DATE CAT CODE INT Indexes ENROLL ENROLL NUM INT ENROLL DATE DATE OSTU_NUM INT CLASS NUM INT The same ERD focusing on the ENROLL entity Indexes STUDENT STU_NUM INT OSTU LNAME VARCHAR(45) STU FNAME VARCHAR(45) STUDY STARTDATE DATE CAT CODE INT Indexes CLASS CLASS NUM CAT_CODE CAT_DESC 202 Undergrad 204 Postgrad 802 Non-degree CLASS CLASS NUM INT CLASS NAME VARCHAR(4) CLASS DUR DECIMAL(102) CLASS STARTDATE DATE Indexes CLASS_NAME 201 Intro to Linear Algebra 101 Biology 101 STUDENTS STU_NUM STUDENT CATEGORIES CAT CODE INT STUDENT CATEGORIES STU_LNAME CAT_DESC VARCHAR(45) CAT LEVEL DECIMAL (62) CAT LAST UDATE DATETIME Indexes 101 Jane 102 John 103 Edison 104 Tendani 105 Jacson CAT LEVEL 12 25 5 CLASS CLASS NUM INT CLASS NAME VARCHAR(45) STU_FNAME Summers Marwala Bawangi Nkosi Mtemba CLASS DUR DECIMAL(10,2) CLASS STARTDATE DATE Indexes STUDENT_CATEGORIES CAT CODE INT CAT DESC VARCHAR(45) CAT LEVEL DECIMAL (6,2) CAT LAST UDATE DATETIME Indexes CLASS DUE CLASS_STARTDATE 100 100 CAT_LAST_UPDATE 01-Jan-23 01-Jan-23 01-Jan-23 STUDY_STARTDATE CAT_CODE 05-Mar-97 03-Mar-99 01-Jul-23 01-Jul-23 05-Jun-00 04-Jan-99 04-Jan-98 202 102 802 204 202
Transcribed Image Text:The ERD focusing on the STUDENT entity ENROLL ENROLL NUM INT ENROLL DATE DATE OSTU NUM INT CLASS NUM INT Indexes STUDENT STU_NUM INT STU_LNAME VARCHAR(45) STU FNAME VARCHAR(45) STUDY STARTDATE DATE CAT CODE INT Indexes ENROLL ENROLL NUM INT ENROLL DATE DATE OSTU_NUM INT CLASS NUM INT The same ERD focusing on the ENROLL entity Indexes STUDENT STU_NUM INT OSTU LNAME VARCHAR(45) STU FNAME VARCHAR(45) STUDY STARTDATE DATE CAT CODE INT Indexes CLASS CLASS NUM CAT_CODE CAT_DESC 202 Undergrad 204 Postgrad 802 Non-degree CLASS CLASS NUM INT CLASS NAME VARCHAR(4) CLASS DUR DECIMAL(102) CLASS STARTDATE DATE Indexes CLASS_NAME 201 Intro to Linear Algebra 101 Biology 101 STUDENTS STU_NUM STUDENT CATEGORIES CAT CODE INT STUDENT CATEGORIES STU_LNAME CAT_DESC VARCHAR(45) CAT LEVEL DECIMAL (62) CAT LAST UDATE DATETIME Indexes 101 Jane 102 John 103 Edison 104 Tendani 105 Jacson CAT LEVEL 12 25 5 CLASS CLASS NUM INT CLASS NAME VARCHAR(45) STU_FNAME Summers Marwala Bawangi Nkosi Mtemba CLASS DUR DECIMAL(10,2) CLASS STARTDATE DATE Indexes STUDENT_CATEGORIES CAT CODE INT CAT DESC VARCHAR(45) CAT LEVEL DECIMAL (6,2) CAT LAST UDATE DATETIME Indexes CLASS DUE CLASS_STARTDATE 100 100 CAT_LAST_UPDATE 01-Jan-23 01-Jan-23 01-Jan-23 STUDY_STARTDATE CAT_CODE 05-Mar-97 03-Mar-99 01-Jul-23 01-Jul-23 05-Jun-00 04-Jan-99 04-Jan-98 202 102 802 204 202
Expert Solution
steps

Step by step

Solved in 3 steps

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