Ingenieria En Informatica

Codigo Mysql
mysql> create database Farmacia;
Query OK, 1 row affected (0.01 sec)

mysql> use Farmacia
Database changed
mysql> create table farmacia
-> (Id_Farmacia int(2),
-> Nombre varchar(30),
-> Calle varchar(30),
-> No_Domicilio varchar(20),
-> Colonia varchar(20),
-> primary key(Id_Farmacia));
Query OK, 0 rows affected (0.03sec)

mysql> create table medicamento
-> (Id_Medicamento int(2),
-> Id_Farmacia int(2),
-> Nombre varchar(20),
-> Tipo varchar(20),
-> Cantidad int(3),
-> Existencia int(3),
-> primary key(Id_Medicamento),
-> foreign key (Id_Farmacia) references farmacia(Id_Farmacia));
Query OK, 0 rows affected (0.02 sec)

mysql> create tablepaciente
-> (Id_Paciente int(2),
-> Nombre varchar(15),
-> Apellido_P varchar(15),
-> Apellido_M varchar(15),
-> Calle varchar(30),
-> No_Domicilio varchar(20),
-> Colonia varchar(20),
-> Edad int(2),
-> Enfermedad varchar(20),
-> primary key(Id_Paciente));
Query OK, 0 rows affected (0.06 sec)

mysql> createtable doctor
-> (Id_Doctor int(2),
-> Nombre varchar(15),
-> Apellido_P varchar(15),
-> Apellido_M varchar(15),
-> Edad int(2),
-> Telefono varchar(12),
-> Calle varchar(30),
-> No_Domicilio varchar(20),
-> Colonia varchar(20),
-> primary key(Id_Doctor));
Query OK, 0 rows affected (0.06 sec)

mysql> create tablereceta
-> (No_Receta int(3),
-> Id_Doctor int(2),
-> Id_Paciente int(2),
-> Id_Medicamento int(2),
-> Fecha varchar(10),
-> primary key(No_Receta),
-> foreign key (Id_Doctor) references doctor(Id_Doctor),
-> foreign key (Id_Paciente) references paciente(Id_Paciente),
-> foreign key (Id_Medicamento) referencesmedicamento(Id_Medicamento));
Query OK, 0 rows affected (0.04 sec)
mysql> create table venta
-> (No_Venta int(3),
-> Id_Medicamento int(2),
-> Id_Paciente int(2),
-> No_Receta int(3),
-> Fecha varchar(10),
-> Precio int(4),
-> Cantidad int(4),
-> primary key(No_Venta),
-> foreign key (Id_Medicamento) references medicamento(Id_Medicamento),-> foreign key (Id_Paciente) references paciente(Id_Paciente),
-> foreign key (No_Receta) references receta(No_Receta));
Query OK, 0 rows affected (0.07 sec)
Insertar Datos a Las Tablas
mysql> insert into farmacia
-> values('2','Fleming','25 Norte','No.14','Solidaridad');
Query OK, 1 row affected (0.00 sec)

mysql> insert into farmacia
->values('3','Guadalajara','25 Norte','No.16','Solidaridad');
Query OK, 1 row affected (0.00 sec)

mysql> insert into farmacia
-> values('4','Similares','25 Norte','No.20','Solidaridad');
Query OK, 1 row affected (0.00 sec)

mysql> insert into farmacia
-> values('5','Similares','40 Sur','No.238','Centro');
Query OK, 1 row affected (0.00 sec)

mysql> insert into farmacia
->values('6','Guadalajara','40 Sur','No.289','Centro');
Query OK, 1 row affected (0.00 sec)

mysql> insert into farmacia
-> values('7','Fleming','2 Norte','No.409','Maravillas');
Query OK, 1 row affected (0.00 sec)

mysql> insert into farmacia
-> values('8','Ahorro','2 Norte','No.4349','Maravillas');
Query OK, 1 row affected (0.01 sec)

mysql> insert into farmacia-> values('9','Ahorro','40 Sur','No.300','Centro');
Query OK, 1 row affected (0.01 sec)

mysql> insert into farmacia
-> values('10','Medina','25 Norte','No.22','Solidaridad');
Query OK, 1 row affected (0.00 sec)

mysql> insert into farmacia
-> values('11','Medina','2 Norte','No.489','Maravillas');
Query OK, 1 row affected (0.00 sec)

mysql> insert into...