Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
database

database

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

Implement the database on DBMS of your choice.
DBMS example: MySQL, SQL server, Oracle, DB2, …
If you have no access to any DBMS, ask for a Database
Server account at Univ.

Hospital Employees Employee ID LastName First Name Educational Hire Date Address City State Zip Home Phone Degree 2 Becker Todd MS. 4-Aug-92 908 W.Capital Way Tacoma WA 98401 (206) S55-9482 Bowie Ros ie B.S. 6-Mar-94 4726 - 11th Ave. N.E. Seatle WA 98105 (206) SSS-1189 3 Carrington Maram MS. 1l-Apr-92 722 Moss Bay Blvd. Kirkland WA 98033 (206) 555-3412 17-Oct-93 Coventy House Mirer Rd. 6 Chu Liu MS. Tacoma WA 98402 (71) 555-73 9 Dennis Ame MS. S-Nov-94 7 Hounds tooth Rd. Bellingham WA 98047 (71) SSS-4444 5 Peters Peter B.S. 17-Oct-93 14 Garett Hill Bellingham WA 98047 (71) 5S5-4948 1-May-92 s07- 20th Ave. E. Apt. 2A Edgeham Hollow Wirches ter Way 3-May-93 4110 Old Redmond Rd. 1 Plotter Mary PhD. Seatle WA 98122 (206) 55S-9857 7 Wally Robert AA. 12-Jan-94 Seatle WA 98125 (71) SSS-5598 4 Walters Magaret MS. Redmond WA 98052 (206) 555-8122
Transcribed Image Text:Hospital Employees Employee ID LastName First Name Educational Hire Date Address City State Zip Home Phone Degree 2 Becker Todd MS. 4-Aug-92 908 W.Capital Way Tacoma WA 98401 (206) S55-9482 Bowie Ros ie B.S. 6-Mar-94 4726 - 11th Ave. N.E. Seatle WA 98105 (206) SSS-1189 3 Carrington Maram MS. 1l-Apr-92 722 Moss Bay Blvd. Kirkland WA 98033 (206) 555-3412 17-Oct-93 Coventy House Mirer Rd. 6 Chu Liu MS. Tacoma WA 98402 (71) 555-73 9 Dennis Ame MS. S-Nov-94 7 Hounds tooth Rd. Bellingham WA 98047 (71) SSS-4444 5 Peters Peter B.S. 17-Oct-93 14 Garett Hill Bellingham WA 98047 (71) 5S5-4948 1-May-92 s07- 20th Ave. E. Apt. 2A Edgeham Hollow Wirches ter Way 3-May-93 4110 Old Redmond Rd. 1 Plotter Mary PhD. Seatle WA 98122 (206) 55S-9857 7 Wally Robert AA. 12-Jan-94 Seatle WA 98125 (71) SSS-5598 4 Walters Magaret MS. Redmond WA 98052 (206) 555-8122
Customers and Pets CustamerID Type of Custamer Custamer Name Street/Apt City State Zip Code Phane Number Fax Number Pet Name PetD Type Of Animal Breed DoB Gender АC001 2 All Creatures 21 Grace St. Tall Pines WA 98746 (206) 555-6622 (206) 555-7854 Bobo AC001-01 RABBIT Long Ear 4/8/92 M Fido AC001-04 DOG German Shepherd 6/1/90 M Presto Chango AC001-02 LIZARD Chameleon 5/1/92 Stinky AC001-03 SKUNK 8/1/91 M AD001 1 Johnathan Adams 66 10th St Mountain View WA 984101012 (206) 555-7623 (206) 555-8855 Patty AD001-01 PIG Potbelly 2/15/91 F Rising Sun AD001-02 HORSE Palomino 4/1 0/90 M AD002 1 William Adams 1122 10th St Lakeville OR 974011011 (503) 555-6187 (503) 555-7319 Dee Dee AD002-01 DOG Miked 2/15/91 F AK001 2 Animal Kingdom 15 Marlin Lane Borderville ID 834835646 (208) 555-7108 Jerry AK001-03 RAT 2/1/88 M Luigi AK001-07 DOG Веagle 8/1/92 M Daily Visits Report CustomerName PetName VisDate Vetainaian ServiceD Treament/Medication Price Adam Johnson Fi Fi 5/9/99 Walters, Margaret T1003 Lab Work - Misc $35.00 T1001 Lab Work - Cerology $75 00 T0300 General Exam $50.00 M0202 Zinc Oxide - 4 oz $7.80 Pet Total: $16780 Customer Total: $16780 All Creatures Fido 11 4/9 8 Carrington, Maram T2003 Flea Spray $25.00 Nyostatine - 1 oz Xaritain Glycon ol - 2 oz MO500 $1 1. 50 MO702 $34. 50 T0404 Repair compl cz fracture $230.00 T0408 Cast affected area $120.00
Transcribed Image Text:Customers and Pets CustamerID Type of Custamer Custamer Name Street/Apt City State Zip Code Phane Number Fax Number Pet Name PetD Type Of Animal Breed DoB Gender АC001 2 All Creatures 21 Grace St. Tall Pines WA 98746 (206) 555-6622 (206) 555-7854 Bobo AC001-01 RABBIT Long Ear 4/8/92 M Fido AC001-04 DOG German Shepherd 6/1/90 M Presto Chango AC001-02 LIZARD Chameleon 5/1/92 Stinky AC001-03 SKUNK 8/1/91 M AD001 1 Johnathan Adams 66 10th St Mountain View WA 984101012 (206) 555-7623 (206) 555-8855 Patty AD001-01 PIG Potbelly 2/15/91 F Rising Sun AD001-02 HORSE Palomino 4/1 0/90 M AD002 1 William Adams 1122 10th St Lakeville OR 974011011 (503) 555-6187 (503) 555-7319 Dee Dee AD002-01 DOG Miked 2/15/91 F AK001 2 Animal Kingdom 15 Marlin Lane Borderville ID 834835646 (208) 555-7108 Jerry AK001-03 RAT 2/1/88 M Luigi AK001-07 DOG Веagle 8/1/92 M Daily Visits Report CustomerName PetName VisDate Vetainaian ServiceD Treament/Medication Price Adam Johnson Fi Fi 5/9/99 Walters, Margaret T1003 Lab Work - Misc $35.00 T1001 Lab Work - Cerology $75 00 T0300 General Exam $50.00 M0202 Zinc Oxide - 4 oz $7.80 Pet Total: $16780 Customer Total: $16780 All Creatures Fido 11 4/9 8 Carrington, Maram T2003 Flea Spray $25.00 Nyostatine - 1 oz Xaritain Glycon ol - 2 oz MO500 $1 1. 50 MO702 $34. 50 T0404 Repair compl cz fracture $230.00 T0408 Cast affected area $120.00
Expert Solution
Step 1

create table statement is used to create tables in SQL.

table name, column name,column data type, column size is mentioned in this query alongwith Primary key, foreign key, not null and other constraints

 

Insert into statements can be used to insert data in these databases.

syntax of insert into:-

INSERT INTO table_name
VALUES (value1, value2, value3, ...);

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
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