Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 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:

image text in transcribed
image text in transcribed
image text in transcribed
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 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linked Data A Geographic Perspective

Authors: Glen Hart, Catherine Dolbear

1st Edition

1000218910, 9781000218916

More Books

Students also viewed these Databases questions