
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN: 9780133594140
Author: James Kurose, Keith Ross
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Acording to the table in the image
Using MySQL commands, answer the following questions ;
(iv) Insert the following data to table students
Matrixnum: S0003
Name: Raudah
(v) Delete the data entered in question (iv)

Transcribed Image Text:(Given the following tables)
students
id
matrixnum
tel_num
name
So0001
Afif
012122222
So0002
Abd Razak
016788900
assesments
id
matrixnum
subject_code quiz
assignment project total_marks grade
1
S00001
MMS3013
80
90
80
83.3
A
S00002
MTD3013
50
80
90
73.3
B
** formula
total_marks = (quiz + assignment + project)/3
subjects
id
subject_code sub_name
credit
1
MMS3013
Web
3
Programming
Database
3
2
MTD3013
Table: Grading
Marks
Grade
80 - 100
A
70 - 79
B
60 - 69
C
50 - 59
D
0- 49
E
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 4 steps with 1 images

Knowledge Booster
Similar questions
- Database coursearrow_forwardtable not copiedarrow_forwardWrite Create Table SQL statements Work Session table The table must have a primary key. The table must have appropriate foreign key constraints. Foreign keys must have the same name, datatype and size of the primary key that they refer to The following columns datatypes and sizes and named constraints must be used Column DataType Constraint WorkYear number(4) Range 2019 - 2020 WorkWeek number(2) Range 1-52 WorkHours number(4,2) Range 0.5 – 99.99 BID NUMBER(4) ,AUTHID NUMBER(4)arrow_forward
- - Delete the employee who has the longest employment in the companyarrow_forwardCREATE TABLE is an example of a Data Manipulation Language (DML) statement. 1) True 2) Falsearrow_forwardcreate tables appointments having columns appointment id as primary key, appointment time, appointment date, doctor id doctors having doctor id as primary key, doctor name providers having provider id as primary key, provider first name, last name, username, password, office code. Now create a provider first name as Lilly , Last name as Brooks, username as Lily_777, password as Brooks_666. Validate on the database also show me the appointments with Dr.Alex at 10.30A.Marrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Computer Networking: A Top-Down Approach (7th Edi...Computer EngineeringISBN:9780133594140Author:James Kurose, Keith RossPublisher:PEARSONComputer Organization and Design MIPS Edition, Fi...Computer EngineeringISBN:9780124077263Author:David A. Patterson, John L. HennessyPublisher:Elsevier ScienceNetwork+ Guide to Networks (MindTap Course List)Computer EngineeringISBN:9781337569330Author:Jill West, Tamara Dean, Jean AndrewsPublisher:Cengage Learning
- Concepts of Database ManagementComputer EngineeringISBN:9781337093422Author:Joy L. Starks, Philip J. Pratt, Mary Z. LastPublisher:Cengage LearningPrelude to ProgrammingComputer EngineeringISBN:9780133750423Author:VENIT, StewartPublisher:Pearson EducationSc Business Data Communications and Networking, T...Computer EngineeringISBN:9781119368830Author:FITZGERALDPublisher:WILEY

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 Engineering
ISBN:9780124077263
Author:David A. Patterson, John L. Hennessy
Publisher:Elsevier Science

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
Computer Engineering
ISBN:9781337093422
Author:Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:Cengage Learning

Prelude to Programming
Computer Engineering
ISBN:9780133750423
Author:VENIT, Stewart
Publisher:Pearson Education

Sc Business Data Communications and Networking, T...
Computer Engineering
ISBN:9781119368830
Author:FITZGERALD
Publisher:WILEY