Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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!?
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started