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:

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

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

Consider a sample with data values of 27, 25, 20, 15, 30, 34, 28, and 25. Provide the five-number summary for the data.

The following are the summarized transactions of dentist Frieda Rivera, DDS for 20X1, her first year in practice: a. Acquired equipment and furniture for $84,000. Its expected useful life is 6 years....

Mr . Big Investor purchased 1 0 0 AA rated bonds issued by Hey You Corporation. He purchased the bonds at 1 0 5 percent of par value, and they are currently trading in the market at 1 0 4 . If the...

Please solve number 7, for letter A and B. 7. Consider that IU=1.66051024g. Determine the average mass in grams of a. One gold atom and the number of atoms in 1.0g of gold. b. One deuterium atom...

Suppose government spending increases. Would the effect on aggregate demand be larger if the Federal Reserve took no action in response or if the Fed were committed to maintaining a fixed interest...

Suppose that people suddenly wanted to hold more money balances. a. What would be the effect of this change on the economy if the Federal Reserve followed a rule of increasing the money supply by 3...

Suppose the federal government cuts taxes and increases spending, raising the budget deficit to 12 percent of GDP. If nominal GDP is rising 5 percent per year, are such budget deficits sustainable...