Question

Write a database description for each of the relations shown, using SQL DDL. Assume the following attribute types:

StudentID(integer, rimary key)

StudentName(25 characters)

FacultyID(integer, primary key)

FacultyName(25 characters)

CourseID (8 characters, primary key)

Answer 1

Step-by-step explanation:

Here in this question we see that their are different types of attribute are present in a table so we making the 3 table

1 student

2 faculty

3 course.

SQL DDL statement for student table here table name is Student1

Create table Student1( StudentID number(15) primary key, StudentName varchar (25) );

Above query create a table student1 with attribute StudentID as primary key constraint and StudentName with 25 characters maximum .This Student1 table is used by various others tables to see the detail of student .

SQL DDL statement for faculty table here table name is Faculty1

create table Faculty1(FacultyID number(15) primary key, FacultyName varchar (25));

Above query create a table Faculty1 with attribute FacultyID as primary key constraint and FacultyName as characters. Faculty is related to many courseID.

SQL DDL statement for Course table here table name is Course1

Create table Course1(CourseID varchar (8) primary key);

Above query create a table Course 1 with attribute CourseID as primary key constraint which is not NULL.