Cover Letters For Trainee Dental Nurse

Code for the creation of the MySQL Database

Amigos_de_la_fiesta create database;
Amigos_de_la_fiesta use database, create table


Plaza (
Key int not null primary key auto_increment, name char
(30), City char (30), Address char (60), capacity int));
create table

Livestock (
id_Ganaderia int not null auto_increment primary key, Location
var (20), Age int, Fec_Creacion var (20));
Attorney

create table ( id_Apoderado
int not null auto_increment primary key, RFC
int, Name char (30), Address char (60), phone int) create

Corrida table (
id_Corrida int not null auto_increment primary key, foreing key index
(Clave_Plaza) references Plaza (Clave_Plaza)
null on September uodate ON DELETE SET NULL,
Order int, char Fair (45), year int));
create table
Toro (

id_Toro int not null auto_increment primary key, foreing key index (id_gana) references Livestock (id_gana)

ON UPDATE SET NULL ON DELETE SET NULL, FOREIGN KEY
index (id_corrida) references run (id_corrida)
on update cascade on delete cascade,
Año_Naci int, int num_orden, colo varchar (20), name varchar (20));

create table Toreros (
id_Torero int not null auto_increment primary key, foreing key index
(id_apo) references Agent (id_apo)
on update cascade on delete cascade, FOREIGN KEY
index (id_Toro) references Toro (id_Toro)
ON UPDATE SET NULL ON DELETE SET NULL
foreing key index (idPremio) references Prize (ipPremio)
on update cascade on delete cascade, RFC
int, Name char (60), Nickname char (20),
FechaAlter char (20), Godfather char (60), char Award (30), Alternative (Bool));
create table

Awards (
id_Premios int, int Ears, Tails int index
foreing key (id_Torero) references Torero (id_Torero) on update cascade
on delete cascade);