[sql] Trabajo Final
Viewer
- CREATE DATABASE `Trabajo Final`;
- CREATE DATABASE partytdata;
- USE partydata;
- CREATE TABLE party (
- Place VARCHAR(25)NOT NULL,
- Address VARCHAR (50) NOT NULL,
- City VARCHAR (25) NOT NULL,
- State VARCHAR (2) NOT NULL,
- Duration INT(6) NOT NULL,
- CREATE TABLE persons(
- PersonID INT(11) NOT NULL,
- LastName VARCHAR(25) NOT NULL,
- FirstName VARCHAR(25) NOT NULL,
- AgeNumber INT(3) NOT NULL,
- ALTER TABLE party
- ADD PRIMARY KEY (Place),
- ADD KEY FK_PersonParty(PersonID);
- ALTER TABLE persons
- ADD PRIMARY KEY (PersonID);
- INSERT INTO persons(PersonID, LastName, FirstName, AgeNumber) VALUES
- (NULL, 'Rodriguez','Javier',25),
- (NULL, 'Castro','Jose',18),
- (NULL, 'Franco','Luis', 29),
- (NULL, 'Wiscovich','Alexander',20),
- (NULL, 'Rivera', 'Alejandra', 24),
- (NULL, 'Elianys', 'Francheska',29),
- (NULL, 'Gonzalez','Veronica',19);
Editor
You can edit this paste and save as new: