• Please Watch the video Lecture recorded below
• https://www.youtube.com/watch?v=CkZ2Q9ItJes
• For table 1 - Create the table and insert records as shown on video
• Add New Three (3) Tables and insert Records shown on the image below

 

AD_DEPARTMENTS: ID 10 20 30 40 AD_COURSES: NAME ACCOUNTING MARK SMITH HEAD BIOLOGY DAVE GOLD COMPUTER SCIENCE LINDA BROWN LITERATURE ANITA TAYLOR NAME SESSION ID DEPT ID LOGON ID PASSWORD BUILDING ROOM DATE TIME 195 190 CELL BIOLOGY 200 20 PRINCIPLES OF 100 22 BUILDING D 401 MWF 9-10 10 BUILDING A 101 MWF 12-1 ACCOUNTING 191 INTRODUCTION TO 100 10 BUILDING B 201 THUR 2-4 BUSINESS LAW 192 COST ACCOUNTING 100 193 STRATEGIC TAX 100 29 10 BUILDING C 301 TUES 5-7 10 TAX123 PASSWORD PLANNING FOR BUSINESS 194 GENERAL BIOLOGY 200 20 20 BIO123 PASSWORD AD_FACULTY: ID FIRST NAME 800 JILL 810 JAMES LAST NAME MILLER BORG EMAIL JMILL@SCHOOL.EDU SALARY 10000 INSURANCE HOURLY RATE DEPT ID HEALTH 20 820 LYNN BROWN 830 ARTHUR SMITH 840 SALLY JONES JBORG@SCHOOLEDU LBROWN@SCHOOLEDU ASMITH@SCHOOLEDU SJONES@SCHOOLEDU 30000 HEALTH, DENTAL 10 50 30 40 10 50000 HEALTH DENTAL, VISION 40