CREATE TABLE Users( C_Id varchar(8) NOT NULL, LastName Varchar(255) NOT NULL, FirstName varchar(255) NOT NULL, ema il varchar(255), Phone int, PRIMARY KÉY (C_Id) CREATE TABLE Restaurants( R_Id...


CREATE TABLE Users(<br>C_Id varchar(8) NOT NULL,<br>LastName Varchar(255) NOT NULL,<br>FirstName varchar(255) NOT NULL,<br>ema il varchar(255),<br>Phone int,<br>PRIMARY KÉY (C_Id)<br>CREATE TABLE Restaurants(<br>R_Id varchar(255) NOT NULL,<br>Rname varchar(255) NOT NULL,<br>Type varchar(255),<br>Raddress varchar(255),<br>Rphone int,<br>Remail varchar(255),<br>PRIMARY KEY(R_Id)<br>);<br>CREATE TABLE RDate(<br>T_num int NOT NULL,<br>Bdate DATE,<br>Rdate DATE,<br>T_start varchar(255),<br>E_start varchar(255),<br>PRIMARY KEY(T_num)<br>);<br>CREATE TABLE Book ingInfo(<br>C_Id varchar(8) NOT NULL,<br>R_Id int NOT NÚLL,<br>PRIMARY KEY(C_Id, R_Id),<br>FOREIGN KEY (C_Ià) REFERENCES Users(C Id),<br>FOREIGN KEY (R_Id) REFERENCES Restaurant(R_Id)<br>);<br>CREATE TABLE Rating(<br>R_Id varchar(255) NÓT NULL,<br>Rating Id varchar(255) NOT NULL,<br>Rate varchar(255) CHECK (Rate>11),<br>Comment LONG,<br>PRIMARY KEY(Rating Id),<br>FOREIGN KEY (R_Id) REFERENCES Restaurants(R_Id)<br>);<br>Create 1 procedure<br>Create 1 function<br>Create 1 database trigger |<br>

Extracted text: CREATE TABLE Users( C_Id varchar(8) NOT NULL, LastName Varchar(255) NOT NULL, FirstName varchar(255) NOT NULL, ema il varchar(255), Phone int, PRIMARY KÉY (C_Id) CREATE TABLE Restaurants( R_Id varchar(255) NOT NULL, Rname varchar(255) NOT NULL, Type varchar(255), Raddress varchar(255), Rphone int, Remail varchar(255), PRIMARY KEY(R_Id) ); CREATE TABLE RDate( T_num int NOT NULL, Bdate DATE, Rdate DATE, T_start varchar(255), E_start varchar(255), PRIMARY KEY(T_num) ); CREATE TABLE Book ingInfo( C_Id varchar(8) NOT NULL, R_Id int NOT NÚLL, PRIMARY KEY(C_Id, R_Id), FOREIGN KEY (C_Ià) REFERENCES Users(C Id), FOREIGN KEY (R_Id) REFERENCES Restaurant(R_Id) ); CREATE TABLE Rating( R_Id varchar(255) NÓT NULL, Rating Id varchar(255) NOT NULL, Rate varchar(255) CHECK (Rate>11), Comment LONG, PRIMARY KEY(Rating Id), FOREIGN KEY (R_Id) REFERENCES Restaurants(R_Id) ); Create 1 procedure Create 1 function Create 1 database trigger |

Jun 04, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here