G11: Databases

// Creates a table with a primary key

CREATE TABLE Band (

  BandName varChar(25) NOT NULL, // Primary Key

  NumberOfMembers integer,

_______ KEY (BandName)

);

// How to delete or drop a table

____ table Band;

// Create table with PK All varchars

CREATE TABLE Venue(

  VenueName _______(25),

  VenueAddress1 varchar(25),

  VenueAddress2 varchar(25),

  PRIMARY Key (VenueName),

  );

//Creates a table with constraint on venue INC Date as datatype

CREATE TABLE Booking(

  BookingID varchar(8),

  Date Date,

  VenueName varchar(25) 

  FOREIGN KEY(VenueName) __________ Venue(VenueName),

  PRIMARY Key (BookingID),

 );

_____ is a collection of data which is ordered and unchangeable. Allows duplicate members.

// INSERTING Values into a table

______ INTO Band (BandName,NumberOfMembers) 

VALUES ('fffbfbbf','6');

INSERT ____ Booking VALUES ('12345678', '1980/02/26', 'theVenue');

// examples of adding a field ‘popular’and bool data type

ALTER TABLE Band

___ Popular Boolean;

// Deleting or dropping the field popular

_____ TABLE Band

DROP popular;

// Specific selects

SELECT BandName 

FROM BandBooking _____ headlining = 'Y'

GROUP BY BandName;