Consider the following few relations ofAcademic systems. Semester ( SemNo , Sem_

Question

Consider the following few relations ofAcademic systems.

Semester (SemNo,Sem_Dur, Start_Date, End_Date)

Department (Deptid, D_Name,Main_Office, HOD)

Write down the Queries for the followinggiven situations.

Create a new data base. Name it VUDBMS.

***.          Showone command for single entry in each relation.

Hint (for b):

Specify the column data type. System oruser-defined data types are acceptable. User-defined data types arecreated with sp_addtype before they can be used ina table definition. The NULL/NOT NULL assignment for a user-defineddata type can be overridden during the CREATE TABLE statement.However, the length specification cannot be changed; you cannotspecify a length for a user-defined data type in a CREATE TABLEstatement.

Following are the roles and responsibilities of each of thegiven entities.

Departments have a professor (known as the HOD **) whoruns the department

Explanation / Answer

Consider the following few relations ofAcademic systems. Semester ( SemNo , Sem_

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.