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...
icon
Related questions
Question

php

2. Create a table and name it as Car_Details with the following 4 fields
Field Name
Туре
Length/Values
Others
Car ID
INT
4
Primary Key,
Auto Increment
Car Model VARCHAR 20
Car_Range VARCHAR 10
Daily_Rent DECIMAL
3. Insert the following records in this Table Car_Details
Car_ID Car_Model Car_Range Daily_Rent
Nissan
SUV
14.5
Тoyota
Salon
10.2
Mazda
4x4
20.6
4. Create a new table and name it as Customer Detail with the
following 3 fields
Field Name
Туре
Length/Values
Others
Cust ID
INT
4
Primary Key,
Auto Increment
Cust_Name VARCHAR 30
Rent Date DATE
5. Create a relationship between the tables Car_Details and
Customer_Detail considering that each customer can rent more than
one car
Hint: add a new field as an Index in Table Customer_Detail and
link it with the Car ID in Car details table
6. Update the Customer Detail table
Cust_ID Cust_Name Rent_Date Car_ID
Ahmed Salim 22-01-2017 1
Salwa Ali
15-01-2017 1
Muneer
CURDATE 2
Transcribed Image Text:2. Create a table and name it as Car_Details with the following 4 fields Field Name Туре Length/Values Others Car ID INT 4 Primary Key, Auto Increment Car Model VARCHAR 20 Car_Range VARCHAR 10 Daily_Rent DECIMAL 3. Insert the following records in this Table Car_Details Car_ID Car_Model Car_Range Daily_Rent Nissan SUV 14.5 Тoyota Salon 10.2 Mazda 4x4 20.6 4. Create a new table and name it as Customer Detail with the following 3 fields Field Name Туре Length/Values Others Cust ID INT 4 Primary Key, Auto Increment Cust_Name VARCHAR 30 Rent Date DATE 5. Create a relationship between the tables Car_Details and Customer_Detail considering that each customer can rent more than one car Hint: add a new field as an Index in Table Customer_Detail and link it with the Car ID in Car details table 6. Update the Customer Detail table Cust_ID Cust_Name Rent_Date Car_ID Ahmed Salim 22-01-2017 1 Salwa Ali 15-01-2017 1 Muneer CURDATE 2
Expert Solution
steps

Step by step

Solved in 2 steps

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