Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
or the following tables’ information, write DDL and DML commands to create database and tables, and entering data into these tables. You need to identify primary keys and foreign keys. Also make sure that you identify all the constraints. (check, default, not null, primary key, foreign key etc)

or the following tables’ information, write DDL and DML commands to create database and tables, and entering data into these tables. You need to identify primary keys and foreign keys. Also make sure that you identify all the constraints. (check, default, not null, primary key, foreign key etc)

A Guide to SQL
A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter3: Creating Tables
Section: Chapter Questions
Problem 4CAT
See similar textbooks
icon
Related questions
Question
100%
For the following tables’ information, write DDL and DML commands to create database and tables, and entering data into these tables. You need to identify primary keys and foreign keys. Also make sure that you identify all the constraints. (check, default, not null, primary key, foreign key etc)
Database Systems - Lab Assignment 1 Deadline : 15th March 2021 11:00PM For the following tables' information, write DDL and DML commands to create database and tables, and entering data into these tables. You need to identify primary keys and foreign keys. Also make sure that you identify all the constraints. (check, default, not null, primary key, foreign key etc) Branch branchNo street city postcode BO05 B007 BO03 BO04 22 Deer Rd 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow |G119QX 32 Manse Rd Bristol 56 Clover Dr London London SWI 4EH BS99 1NZ BO02 NW10 6EU| Staff staffNo fName IName position sex DOB salary branchNo 30000 BO05 | 10-Nov-60 12000 |BO03 24-Mar-58 18000 19-Feb-70 | 9000 SL21 John White Manager M 1-Oct-45 SG37 Ann Beech Assistant F SG14 David Ford Supervisor M BO03 SA9 Mary Howe Assistant F BO07 Brand Manager 3-Jun-40 13-Jun-65 9000 SG5 Susan F 24000 BO03 SL41 Julie Lee Assistant F BO05 PropertyForRent propertyNo street city postcode type rooms rent ownerNo staffNo branchNo Aberdeen AB7 5SU London 6 Lawrence St Glasgow |G11 9QX Glasgow G32 4QX Glasgow G12 Glasgow |G12 9AX 650 |CO46 400 CO87 350 CO40 375 CO93 600 |CO87 PA14 16 Holhead House 6 SA9 BO07 PL94 6 Argyll St NW2 Flat 4 SL41 B005 PG4 Flat 3 BO03 PG36 2 Manor Rd Flat 3 SG37 BO03 PG21 18 Dale Rd House 5 SG37 BO03 PG16 5 Novar Dr Flat 4 450 CO93 SG14 BO03
Transcribed Image Text:Database Systems - Lab Assignment 1 Deadline : 15th March 2021 11:00PM For the following tables' information, write DDL and DML commands to create database and tables, and entering data into these tables. You need to identify primary keys and foreign keys. Also make sure that you identify all the constraints. (check, default, not null, primary key, foreign key etc) Branch branchNo street city postcode BO05 B007 BO03 BO04 22 Deer Rd 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow |G119QX 32 Manse Rd Bristol 56 Clover Dr London London SWI 4EH BS99 1NZ BO02 NW10 6EU| Staff staffNo fName IName position sex DOB salary branchNo 30000 BO05 | 10-Nov-60 12000 |BO03 24-Mar-58 18000 19-Feb-70 | 9000 SL21 John White Manager M 1-Oct-45 SG37 Ann Beech Assistant F SG14 David Ford Supervisor M BO03 SA9 Mary Howe Assistant F BO07 Brand Manager 3-Jun-40 13-Jun-65 9000 SG5 Susan F 24000 BO03 SL41 Julie Lee Assistant F BO05 PropertyForRent propertyNo street city postcode type rooms rent ownerNo staffNo branchNo Aberdeen AB7 5SU London 6 Lawrence St Glasgow |G11 9QX Glasgow G32 4QX Glasgow G12 Glasgow |G12 9AX 650 |CO46 400 CO87 350 CO40 375 CO93 600 |CO87 PA14 16 Holhead House 6 SA9 BO07 PL94 6 Argyll St NW2 Flat 4 SL41 B005 PG4 Flat 3 BO03 PG36 2 Manor Rd Flat 3 SG37 BO03 PG21 18 Dale Rd House 5 SG37 BO03 PG16 5 Novar Dr Flat 4 450 CO93 SG14 BO03
Client clientNo fName IName telNo prefType maxRent CR76 John 0207-774-5632| Flat Кay Stewart 0141-848-1825 | Flat Ritchie 01475-392178|House Tregear 01224-196720| Flat 425 CR56 Aline 350 CR74 Mike 750 CR62 Mary 600 PrivateOwner ownerNo fName IName address telNo 2 Fergus Dr, Aberdeen AB2 7SX | 01224-861212 6 Achray St, Glasgow G32 9DX | 0141-357-7419 CO46 Joe Кeogh |CO87 Carol Farrel Murphy 63 Well St, Glasgow G42 Shaw CO40 Tina 0141-943-1728 CO93 Tony 12 Park Pl, Glasgow G4 0QR 0141-225-7025
Transcribed Image Text:Client clientNo fName IName telNo prefType maxRent CR76 John 0207-774-5632| Flat Кay Stewart 0141-848-1825 | Flat Ritchie 01475-392178|House Tregear 01224-196720| Flat 425 CR56 Aline 350 CR74 Mike 750 CR62 Mary 600 PrivateOwner ownerNo fName IName address telNo 2 Fergus Dr, Aberdeen AB2 7SX | 01224-861212 6 Achray St, Glasgow G32 9DX | 0141-357-7419 CO46 Joe Кeogh |CO87 Carol Farrel Murphy 63 Well St, Glasgow G42 Shaw CO40 Tina 0141-943-1728 CO93 Tony 12 Park Pl, Glasgow G4 0QR 0141-225-7025
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS