Implementacion de la base de datos

 

mysql> CREATE DATABASE veterinaria;

Query OK, 1 row affected

mysql> SHOW DATABASES;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sakila |

| test |

 

|veterinaria|

| world |

+--------------------+

7 rows in set

mysql> USE veterinaria;

Query OK, 0 rows affected

mysql> CREATE TABLE perro (ID_Perro VARCHAR(6) NOT NULL PRIMARY KEY, Sexo VARCHAR(15) NOT NULL, Fecha_Nacimiento DATE NOT NULL, Especie VARCHAR(15) NOT NULL, Peso VARCHAR(10) NOT NULL, Raza VARCHAR(20) NOT NULL, Alzada VARCHAR(20) NOT NULL, Nombre VARCHAR(25) NOT NULL);

Query OK, 0 rows affected

mysql> SHOW TABLES;

+-------------------+

| Tables_in_veterinaria |

+-------------------+

| perro           |

+-------------------+

1 row in set

mysql> CREATE TABLE Datos_Del_Propietario (ID_Propietario VARCHAR(10) PRIMARY KEY NOT NULL, Nombre_Propietario VARCHAR(30) NOT NULL, Ocupacion VARCHAR(20) NOT NULL, Direccion VARCHAR(30) NOT NULL, Telefono INT(15) NOT NULL);

Query OK, 0 rows affected

mysql>

mysql> SHOW TABLES;

+-----------------------+

| Tables_in_clinica |

+-----------------------+

| datos_del_propietario |

| mascota |

+-----------------------+

2 rows in set

mysql> CREATE TABLE Caracteristicas_Especiales (ID_Mascota VARCHAR(6) PRIMARY KEY NOT NULL, Color VARCHAR(20) NOT NULL, Condicion_Corporal VARCHAR(20) NOT NULL, Pelaje VARCHAR(20) NOT NULL, Tatuajes VARCHAR(20), Cicatrises VARCHAR(20), Fin_Zootecnico VARCHAR(20), Cirujias_Esteticas VARCHAR(20));

Query OK, 0 rows affected

mysql> SHOW TABLES;

+----------------------------+

| Tables_in_clinica |

+----------------------------+

| caracteristicas_especiales |

| datos_del_propietario |

| perro      |

+----------------------------+

3 rows in set

mysql> CREATE TABLE Consulta(ID_Mascota VARCHAR(6) PRIMARY KEY NOT NULL, Enfermedad VARCHAR(20), Urgencia VARCHAR(20), Revision VARCHAR(20), Estetica VARCHAR(20));

Query OK, 0 rows affected

mysql> SHOW TABLES;

+----------------------------+

| Tables_in_clinica |

+----------------------------+

| caracteristicas_especiales |

| consulta |

| datos_del_propietario |

| perro   |

+----------------------------+

4 rows in set

mysql> CREATE TABLE Antecedentes(ID_Mascota VARCHAR(6) PRIMARY KEY NOT NULL, Fecha DATE NOT NULL, Tratamiento VARCHAR(50) NOT NULL);

Query OK, 0 rows affected

mysql> show tables;

+----------------------------+

| Tables_in_clinica |

+----------------------------+

| antecedentes |

| caracteristicas_especiales |

| consulta |

| datos_del_propietario |

| perro|

+----------------------------+

5 rows in set

mysql> CREATE TABLE Medio_Ambiente(Entorno VARCHAR(50), Nutricion VARCHAR(50), Estilo_de_Vida VARCHAR(50));

Query OK, 0 rows affected

mysql> show tables;

+----------------------------+

| Tables_in_clinica |

+----------------------------+

| antecedentes |

| caracteristicas_especiales |

| consulta |

| datos_del_propietario |

| perro   |

| medio_ambiente |

+----------------------------+

6 rows in set

mysql> CREATE TABLE Historia_Medica(Temperatura DOUBLE, Frecuencia_Respiratoria VARCHAR(30), Pulso DOUBLE, Frecuencia_Cardiaca VARCHAR(30));

Query OK, 0 rows affected

mysql> SHOW TABLES;

+----------------------------+

| Tables_in_clinica |

+----------------------------+

| antecedentes |

| caracteristicas_especiales |

| consulta |

| datos_del_propietario |

| historia_medica |

| perro   |

| medio_ambiente |

+----------------------------+

7 rows in set