SQL Database Schema: Doctors, Patients, and Care

Posted by on Mar 18, 2025 in Cinema and Television | 0 comments

SQL Database Schema for Medical Records

Creating Tables

SQL code to create the Medico (Doctor), Paciente (Patient), and Atencion (Care) tables:


CREATE TABLE Medico (
 rut VARCHAR2(20) NOT NULL,
 nombre VARCHAR2(90) NOT NULL,
 apellidos VARCHAR2(80) NOT NULL,
 email VARCHAR2(70),
 sueldo NUMBER(20) NOT NULL,
 CONSTRAINT medico_pk PRIMARY KEY(rut)
);

CREATE TABLE Paciente (
 id NUMBER(20) NOT NULL,
 rut VARCHAR2(15) NOT NULL,
 nombre_completo VARCHAR2(200) NOT NULL,
 fecha_nacimiento DATE NOT NULL,
Read More

Understanding Physical Examinations & Medical History

Posted by on Feb 22, 2025 in Health and Nursing | 0 comments

Understanding the Physical Examination Process

A physical examination is a routine test where a doctor assesses your overall health. It involves several techniques and instruments to evaluate your condition and identify potential health issues.

Key Verbs and Vocabulary:

Here are some common words and their translations, useful for understanding medical discussions:

  • Can: Poder (to be able to)
  • Be: Ser (to be)
  • Have: Tener/Haber (to have)
  • With: Con (with)
  • To: A, Para (to, for)
  • But: Pero, Sino (but)
  • Way: Manera,
Read More

MEDICINA

Posted by on Apr 10, 2020 in Law & Jurisprudence | 0 comments

76-year-old Eric Baker slipped on a wet bathroom floor. FALLS

AREN´T THERE ANY health care assistants available? No, there AREN´T

Choose the correct answer: I’VE SEEN THE DOCTOR ALREADY

Choose the correct answer: The waiting room is ON The second floor NEXT TO the lift. 

Choose the correct answer: Who does work with your doctor in the hospital? 

Choose the correct answer: You treated that patient a month ago, didn’t you?

Costa del Sol Hospital is BIGGER THAN Serranía de Ronda Hospital, but it isn’

Read More

IFNAGSGN

Posted by on Sep 12, 2019 in Spanish | 0 comments

NIVEL 1= 1)You ARE a student. 2)HeS from Canada. 3)We ARENT from Brasil. We re from Perú. 4) Hes my brother. HIS name is Martin. 5) My mother is from Argentina but HER parents are from Italy. 6)SARA”S brother is Tomas. 7)I have two DESKS. 8)His CHILDREN are Marc, Saskia and Alina. 9)THAT coat is Peters. 10)THESE trainers are new. 11)There ARE two chairs in my living room. 12)There ISNT any money in my wallet. 13)Are the books ON the chair? 14)The sofa is BETWEEN the two Windows. 15)I WORK in

Read More