Consider the structure of three table department, computer and employee as shown below. John, a database admin would like to remove all three tables from database as they no longer are being used. Identify the correct commands.
department:
Column Name Data Type/Size Description Constraints
dept_id integer Department id primary key
dept_name varchar (30) Department name not null
computer:
Column Name Data Type/Size Description Constraints
comp_id integer Computer id primary key
comp_make varchar (30) Computer make not null
employee:
Column Name Data Type/Size Description Constraints
emp_id integer Employee id primary key
emp_name Varchar (30) Employee name not null
comp_id integer Computer id Foreign key referring to comp_id column of computer table
dept_id varchar (30) Department id Foreign key referring to dept_id column of department table

Question

Consider the structure of three table department, computer and employee as shown below. John, a database admin would like to remove all three tables from database as they no longer are being used. Identify the correct commands.

department:

Column Name	Data Type/Size	Description	Constraints
dept_id	integer	Department id	primary key
dept_name	varchar (30)	Department name	not null

computer:

Column Name	Data Type/Size	Description	Constraints
comp_id	integer	Computer id	primary key
comp_make	varchar (30)	Computer make	not null

employee:

Column Name	Data Type/Size	Description	Constraints
emp_id	integer	Employee id	primary key
emp_name	Varchar (30)	Employee name	not null
comp_id	integer	Computer id	Foreign key referring to comp_id column of computer table
dept_id	varchar (30)	Department id	Foreign key referring to dept_id column of department table

anonymous · Accepted Answer

Correct Solution - cd

Important Links