Ask Question
7 June, 16:34

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)

+3
Answers (1)
  1. 7 June, 18:10
    0
    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.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “Write a database description for each of the relations shown, using SQL DDL. Assume the following attribute types: StudentID (integer, ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers