Write appropriate SQL DDL statements Create Table Statements

Write appropriate SQL DDL statements (Create Table Statements) for declaring the following relational database schema. Specify appropriate primary keys, referential keys, and other constraints.

RESEARCHER Name Title EXPERIMENT Eid Date Time X# MICROARRAY Mid Platform Organism Tissue CONTAIN Eid Mid

Solution

DDL statements for researcher,Experiment, MidArray,Contain table
Create Table Researcher
(
  X# int Not Null,
Name Varchar(20),
Tilte Varchar(20),
Primary Key(X#)
);

Create Table Experiment
(
Eid int Not Null,
Date Date,
Time Date,
X# int,
Primary Key(Eid),
Foreign Key(X#) References Researcher(X#)
);

Create Table MicroArray
(
  Mid int Not Null,
  Platform varchar(20),
Organism varchar(20),
Tissue varchar(20),
Primary Key(Mid)
);

Create Table Contain
(

Eid int,
Mid int,
ForeignKey(Eid) References Experiment(Eid),
ForeignKey(Mid) References MidArray(Mid)
);

For further queries kindly get back