Question: Please complete and submit your lab work here. We have the following tables of Student, Course, and Registeration in the databas. Your job is to

Please complete and submit your lab work here.

We have the following tables of Student, Course, and Registeration in the databas. Your job is to create all three tables, define aproperiate data type for each attribute, and speceify all constarints that might be exist in our database. Then, you have to insert all data to the tables.

The data we need to insert in the tables is as below: Note: Use SQL

to create all three tables, define aproperiate data type for each attribute,

STD_ID STD_NAME GENDER DOB 1111 Ahmed M 23-DEC-86 2222 ALi M . 01-JAN-01 3333 Huda F 02-JAN-10 4444 Noor F 01-JAN-11 COURSEID CNAME CREDITS DPT_ID 340CIS-3 Database 3 IS 380CIS-3 Information Systems 3 IS 410CIS-3 Operating Systems 3 CS 101 Math-3 Math 3 SC STD_ID COURSEID SEC_NO START_DATE 1111 340CIS-3 90 02-JAN-21 1111 380CIS-3 101 04-JUN-21 1111 101 Math-3 8 04-JUN-20 2222 340CIS-3 90 02-JAN-21 2222 380CIS-3 101 04-JUN-21 3333 340CIS-3 90 02-JAN-21 1111 380CIS-3 8 04-AUG-21

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Please complete and submit your lab work here. We have the following tables of Student, Course, and Registeration in the databas. Your job is to create all three tables, define aproperiate data type...

We have the following tables of Student, Course, and Registeration in the databas. Your job is to create all three tables, define aproperiate data type for each attribute, and speceify all...

After having the opportunity to complete the course, what would you change and why? What topic particularly caught your interest and what do you want to know more about? Last, but not least, if you...

PSYC 355 LAB PROJECT OVERVIEW AND INSTRUCTIONS It is very important that students of statistics know how to choose the correct analysis for a given research question, collect the data, run the test,...

Study Guide Strategic Business Management By A. J. Cataldo About the Author A. J. Cataldo is currently a professor of accounting at West Chester University, in West Chester, Pennsylvania. He holds a...

I would like assist for my assessment. The subject is Subsidiary Accounts and Ledgers and Foundation Skills. T-1.8.1 Details of Assessment Term and Year 1, 2017 Time allowed Week 2-7 Assessment No 1...

1 PM665 Project Management Capstone Project Name Your Name Date 2 Table of Contents 1.0 Introduction...

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

The 150-lb crate is supported by cables AB, AC, and AD. The magnitude of the tension in cable AC is 242 lb and the tension vector of the cable AD is given by FAD = 346 k. Determine the magnitude of...

You are given two choices of investments, Investment A and Investment B. Both investments have the same future cash flows. Investment A has a discount rate of 4%, and Investment B has a discount rate...

Plot the position of the following firms on Figure 12.6: Procter & Gamble, IBM, Nokia, Coca-Cola, Dow Chemicals, US Steel, McDonalds. In each case justify your answer.

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

How has Departmental Computing increased the need for HCM Professionals and Technical Staff to be skilled in Business Computing Software and Systems?

Describe the difference between Two- and Three-Tier Computing Systems.

Explain the differences between On Premises, SaaS, PaaS, IaaS, and Hybrid Computing environments.