Answered step by step
Verified Expert Solution
Link Copied!

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!?image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Horse Betting The Road To Absolute Horse Racing 2

Authors: NAKAGAWA,YUKIO

1st Edition

B0CFZN219G, 979-8856410593

More Books

Students also viewed these Databases questions

Question

1.what is the significance of Taxonomy ?

Answered: 1 week ago

Question

What are the advantages and disadvantages of leasing ?

Answered: 1 week ago

Question

Name is needed for identifying organisms ?

Answered: 1 week ago