Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
There are sample datasets for the CLASS, STUDENT_CATEGORIES and STUDENT tables. 4) Provide the SQL statement to enroll Tendani to the Biology 101 class on 1/2/2024

There are sample datasets for the CLASS, STUDENT_CATEGORIES and STUDENT tables. 4) Provide the SQL statement to enroll Tendani to the Biology 101 class on 1/2/2024

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.

4) Provide the SQL statement to enroll Tendani to the Biology 101 class on 1/2/2024

 

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