• The list of tables the group decided to include in the final group database. Include all attributes and constraints for each table.
• Screen shots to verify the creation of the tables you were assigned by the group.
  • Use the SQL Command Line utility (preferably using Oracle) to create the table structures and constraints assigned to you by the group.
  • Include a screen shot to verify the successful completion of each Create Table command. Each Screen shot must be preceded by a comment that includes the student’s name, the instructor’s name, and the date the command was executed.
  • SQL>/* Student: Yatavia Summers Instructor: Michael Collins Date: date the command was executed */
  • Note: Don’t forget the /* and */ at the start and end of the command to make it into a comment!!
  • The screen shot must include the SQL command and the output from the command.
  • Include one screen shot for each table created. The screen shots must be well formatted and the output easily readable

  The table structures and constraints assigned to me by the group

• CREATE TABLE Station (StationID VARCHAR (6) CONSTRAINT check_StationID CHECK (StationID LIKE 'S_____'),Street VARCHAR (20) NOT NULL,City VARCHAR (20) NOT NULL,State VARCHAR (20) NOT NULL,ZipCode VARCHAR (20) NOT NULL,PhoneNo VARCHAR (11) NOT NULL,CONSTRAINT PK_Station PRIMARY KEY (StationID));

CREATE TABLE Vehicle (

EquipmentID VARCHAR (7) CONSTRAINT check_EquipmentID CHECK (EquipmentID LIKE 'V______',

Make VARCHAR (20) NOT NULL,

Model VARCHAR (20) NOT NULL,

Type VARCHAR (20) NOT NULL,

Mileage NUMBER (8, 2) NOT NULL,

AccidentCount NUMBER (10) NOT NULL DEFAULT 0,

CONSTRAINT PK_Vehicle PRIMARY KEY (EquipmentID),

CONSTRAINT FK_Vehicle FOREIGN KEY (EquipmentID) REFERENCES Equipment (EquipmentID)

);