BD y DIAGRAMA DE E/R

Microsoft Windows [Versión 6.1.7601]

Copyright (c) 2009 Microsoft Corporation. Reservados todos los derechos.

C:\Users\Chiquita>cd..

C:\Users>cd..

C:\>cd xampp

C:\xampp>cd mysql

C:\xampp\mysql>cd bin

C:\xampp\mysql\bin>mysql -hlocalhost -uroot -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.5.16 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql> CREATE DATABASE VETERINARIA;

Query OK, 1 row affected (1.44 sec)

 

mysql> USE VETERINARIA;

Database changed

mysql> CREATE TABLE PROPIETARIO(Id_PROPIETARIO INT NULL PRIMARY KEY,

NOMBRE VARCHAR(20),

DIRECCION VARCHAR(20),

TELEFONO VARCHAR(10),

PROFECCION VARCHAR(20));

Query OK, 0 rows affected (1.16 sec)

 

mysql> CREATE TABLE CARACTERISTICAS(Id_MASCOTA INT NULL PRIMARY KEY,

COLOR VARCHAR(10),

PELAJE VARCHAR(10),

CICATRICES VARCHAR(10),

TATUAJES VARCHAR(10),

CIRUGIAS VARCHAR(10),

CONDICION_CORPORAL VARCHAR(10),

FIN_ZOOTECNICO VARCHAR(10));

Query OK, 0 rows affected (0.55 sec)

 

mysql> CREATE TABLE HISTORIA_MEDICA(Id_HISTORIAMEDICA INT NULL PRIMARY KEY,

CONSTANTES_FISOLOGICAS VARCHAR(20),

TEMPERATURA VARCHAR(10),

FRECUENCIA_CARDIACA VARCHAR(5),

FRECUENCIA_RESPIRATORIA VARCHAR(20),

PULSO VARCHAR(10));

Query OK, 0 rows affected (0.99 sec)

 

mysql> CREATE TABLE MEDIOS_AMBIENTALES(Id_TRATAMIENTO INT NULL PRIMARY KEY,

ENTORNO VARCHAR(30),

NUTRICION VARCHAR(25),

ESTILODE_VIDA VARCHAR(30));

Query OK, 0 rows affected (0.24 sec)

 

mysql> CREATE TABLE ANTECEDENTES(Id_DIAGNOSTICO INT PRIMARY KEY,

DIAGNOSTICO VARCHAR(40),

TRATAMIENTO VARCHAR(70),

Id_TRATAMIENTO INT REFERENCES MEDIOS_AMBIENTALES);

Query OK, 0 rows affected (3.16 sec)

 

mysql> CREATE TABLE CONSULTA(Id_CONSULTA INT PRIMARY KEY,

MOTIVO VARCHAR(30),

FECHA DATE,

Id_DIAGNOSTICO INT REFERENCES ANTECEDENTES,

Id_HISTORIAMEDICA INT REFERENCES HISTORIA_MEDICA);

Query OK, 0 rows affected (0.93 sec)

 

mysql> CREATE TABLE MASCOTA(Id_MASCOTA INT REFERENCES CARACTERISTICAS,

Id_PROPIETARIO INT REFERENCES PROPIETARIO,

Id_CONSULTA INT REFERENCES CONSULTA,

NOMBRE VARCHAR (20),

SEXO VARCHAR(10),

FCH_NACIMIENTO DATE,

ESPECIE VARCHAR(20), RAZA VARCHAR(20));

Query OK, 0 rows affected (0.92 sec)

 

mysql> INSERT INTO PROPIETARIO (Id_PROPIETARIO,NOMBRE,DIRECCION,TELEFONO,PROFECCION) VALUES (1234,'LEONARDO PEREZ','MEJIA 2030','6566305622','ING. INDUSTRIAL');

Query OK, 1 rowaffected (0.25 sec)

mysql> INSERT INTO PROPIETARIO Id_PROPIETARIO,NOMBRE,DIRECCION,TELEFONO,PROFECCION) VALUES (1235,'ANTONIO LOPEZ','LA TULE 270','6566302980','ING. CIVIL'),

-> (1236,'MARCO BARRAZA','ROSALES 483','6566920343','DENTISTA'),

-> (1237,'DANIEL DELGADO','DE LEON 3920-20','6562391038','CIRUJANO');

Query OK, 3 rows affected (0.71 sec)

Records: 3  Duplicates: 0  Warnings: 0

 

mysql> SELECT * FROM PROPIETARIO;

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

| Id_PROPIETARIO | NOMBRE         | DIRECCION       | TELEFONO   | PROFECCION|

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

|           1234 | LEONARDO PEREZ | MEJIA 2030      | 6566305622 | ING. INDUSTRIAL |

|           1235 | ANTONIO LOPEZ  | LA TULE 270     | 6566302980 | ING. CIVIL               |

|           1236 | MARCO BARRAZA  | ROSALES 483     | 6566920343 | DENTISTA          |

|           1237 | DANIEL DELGADO | DE LEON 3920-20 | 6562391038 | CIRUJANO|

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

4 rows in set (0.15 sec)

 

mysql> INSERT INTO CARACTERISTICAS (Id_MASCOTA,COLOR,PELAJE,CICATRICES,CIRUGIAS,TATUAJES,CONDICION_CORPORAL,FIN_ZOOTECNICO) VALUES (1234,'NEGRO','GRUESO','NO','SI','NO','EXCELENTE','ESTOMAGO SOBRECARGADO'),

-> (1334,'NEGRO','FINA','NO','NO','NO','EXCELENTE','CIRUJIA EN ESTOMAGO'),

-> (1434,'CAFE','SINGULAR','NO','NO','SI','DELGADO','BOMITO BLANCO'),

-> (1534,'CAFE','FINA','NO','NO','NO','DELGADO','CHEQUEO NORMAL');

Query OK, 4 rows affected, 4 warnings (0.76 sec)

Records: 4  Duplicates: 0  Warnings: 4

 

mysql> INSERT INTO HISTORIA_MEDICA (Id_HISTORIAMEDICA,CONSTANTES_FISOLOGICAS,TEMPERATURA,FRECUENCIA_CARDIACA,FRECUENCIA_RESPIRATORIA,PULSO) VALUES (2345,'NINGUNA','40°','NORMAL','NORMAL','NORMAL'),

-> (2346,'NINGUNA','40°','NORMAL','NORMAL','NORMAL'),

-> (2347,'NINGUNA','40°','NORMAL','NORMAL','NORMAL'),

-> (2348,'NINGUNA','40°','NORMAL','NORMAL','NORMAL');

Query OK, 4 rows affected, 4 warnings (0.96 sec)

Records: 4  Duplicates: 0  Warnings: 4

 

mysql> INSERT INTO MEDIOS_AMBIENTALES (Id_TRATAMIENTO,ENTORNO,NUTRICION,ESTILODE_VIDA) VALUES (12,'NORMAL','SALUDABLE','REGULAR'),

-> (15,'NORMAL','SALUDABLE','REGULAR'),

-> (19,'NORMAL','SALUDABLE','REGULAR'),

-> (23,'NORMAL','SALUDABLE','REGULAR');

Query OK, 4 rows affected (0.76 sec)

Records: 4  Duplicates: 0  Warnings: 0

 

mysql> INSERT INTO ANTECEDENTES (Id_DIAGNOSTICO,DIAGNOSTICO,Id_TRATAMIENTO,TRATAMIENTO) VALUES (23,'NINGUNO',15,'NINGUNO');

Query OK, 1 row affected (0.71 sec)

 

mysql> INSERT INTO ANTECEDENTES(Id_DIAGNOSTICO,DIAGNOSTICO,Id_TRATAMIENTO,TRATAMIENTO) VALUES (23,'NINGUNO',15,'NINGUNO'),

-> (24,'NINGUNO',19,'NINGUNO'),

-> (22,'NINGUNO',12,'NINGUNO'),

-> (25,'NINGUNO',23,'NINGUNO');

ERROR 1062 (23000): Duplicateentry '23' forkey 'PRIMARY'

mysql>

DIAGRAMA HISTORIA CLINICA