Question: HOW DO I SOLVE THIS!? CREATE TABLE Evert (name VARCHAR(10) PRIMARY KEY. events_date DATE); CREATE TABLE Person (cardrum INTEGER, address VARCHAR(50), fullname VARCHAR(30) event_name VARCHAR(10)

HOW DO I SOLVE THIS!?HOW DO I SOLVE THIS!? CREATE TABLE Evert (name VARCHAR(10) PRIMARY KEY.

CREATE TABLE Evert (name VARCHAR(10) PRIMARY KEY. events_date DATE); CREATE TABLE Person (cardrum INTEGER, address VARCHAR(50), fullname VARCHAR(30) event_name VARCHAR(10) REFERENCES Evert(name), PRIMARY KEY(cardnum.event_name)); CREATE TABLE Person (cardnum INTEGER PRIMARY KEY, address VARCHAR(50), fullname VARCHAR(30)); CREATE TABLE Evert (name VARCHAR(10) PRIMARY KEY. event_date DATE); CREATE TABLE Attends (person INTEGER REFERENCES Person(cardnum), event VARCHAR (10) REFERENCES Event(name), PRIMARY KEY(event)); CREATE TABLE Person (cardnum INTEGER PRIMARY KEY, address VARCHAR(50), fullname VARCHAR(30)); CREATE TABLE Evert (name VARCHAR (10) PRIMARY KEY, event_date DATE); CREATE TABLE Attends (person INTEGER REFERENCES Person(cardnum), event VARCHAR (10) REFERENCES Event(name), PRIMARY KEY (person, event)); CREATE TABLE Person (cardnum INTEGER PRIMARY KEY, address VARCHAR(50), fullname VARCHAR(30)); CREATE TABLE Event (name VARCHAR(10) PRIMARY KEY, event_date DATE); CREATE TABLE Attends (person INTEGER REFERENCES Person(cardnum), event VARCHAR (10) REFERENCES Event(name). PRIMARY KEY(person)); CREATE TABLE Person (cardnum INTEGER PRIMARY KEY, address VARCHAR(50), fullname VARCHAR(30)); CREATE TABLE Event (person INTEGER REFERENCES Person(cardnum), name VARCHAR(10), event_date DATE. PRIMARY KEY(person.event_date))

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!