• ¿Documento equivocado? Cámbialo gratis
  • Escrito por estudiantes que aprobaron
  • Inmediatamente disponible después del pago
  • Leer en línea o como PDF
Vender
¿Dónde estudias?
Tu idioma
Document preview thumbnail
Vista previa 2 fuera de 6 páginas
Caso

Case Study – Database Design

Document preview thumbnail
Vista previa 2 fuera de 6 páginas

CASE STUDY – DATABASE DESIGN Case Study Database Design Richard Harris DeVry University CASE STUDY – DATABASE DESIGN CASE STUDY – DATABASE DESIGN CASE STUDY – DATABASE DESIGN CASE STUDY – DATABASE DESIGN A small surgery center requires a new database. The office manager has identified the following types of data: patients, doctors, procedures and appointments. From this data requirement the following main entities have been created: Patient, Doctor, Appointment and Procedure. The relationships between the main entities can be explained as follows: • Doctors can see many patients (many to many relationship) • Patients can have many procedures (many to many relationship) • Doctors can service many appointments (many to many relationship) Due to the multiple many to many relationships between the main entities, then it is necessary to create associative tables to join the main tables together. The associative tables are: Join Patient Procedure, Join Doctor Patient and Join Doctor Appointment. The following tables detail the entities, their attributes, the data types of each attribute, if the attribute is a primary or foreign key and whether or not the attribute is required. PATIENT ENTITY Attribute (P)rimary/(F)oreign Data Type Required Key Patient ID P Short text (10) Y Last name Short text (25) Y First name Short text (25) Y Date of birth Date/time Y Social security number Short text (10) Y Sex Short text (1) Y Street address Short text (25) Y City Short text (20) Y State Short text (2) Y Postal code Short text (10) Y Phone number Short text (10) N DOCTOR ENTITY Attribute (P)rimary/(F)oreign Data Type Required Key Doctor ID P Short text (10) Y Last Name Short text (25) Y First name Short text (25) Y Specialty Short text (25) N JOIN PATIENT PROCEDURE ENTITY Attribute (P)rimary/(F)oreign Data Type Required Key Join Pat Proc ID P Short text (10) Y Doctor ID F Short text (10) Y Appointment ID F Short text (10) Y JOIN DOCTOR PATIENT ENTITY Attribute (P)rimary/(F)oreign Data Type Required Key

Vista previa del contenido

CASE STUDY – DATABASE DESIGN
1


Case Study


Database Design


Richard Harris


DeVry University




CASE STUDY – DATABASE DESIGN
CASE STUDY – DATABASE DESIGN
CASE STUDY – DATABASE DESIGN
CASE STUDY – DATABASE DESIGN

, CASE STUDY – DATABASE DESIGN
2




A small surgery center requires a new database. The office manager has identified the

following types of data: patients, doctors, procedures and appointments. From this data

requirement the following main entities have been created: Patient, Doctor, Appointment and

Procedure. The relationships between the main entities can be explained as follows:


Doctors can see many patients (many to many relationship)

Patients can have many procedures (many to many relationship)

Doctors can service many appointments (many to many relationship)

Due to the multiple many to many relationships between the main entities, then it is

necessary to create associative tables to join the main tables together. The associative tables are:

Join Patient Procedure, Join Doctor Patient and Join Doctor Appointment. The following tables

detail the entities, their attributes, the data types of each attribute, if the attribute is a primary or

foreign key and whether or not the attribute is required.


PATIENT ENTITY
Attribute (P)rimary/(F)oreign Data Type Required
Key
Patient ID P Short text (10) Y
Last name Short text (25) Y
First name Short text (25) Y
Date of birth Date/time Y
Social security number Short text (10) Y
Sex Short text (1) Y
Street address Short text (25) Y
City Short text (20) Y
State Short text (2) Y
Postal code Short text (10) Y
Phone number Short text (10) N

Información del documento

Subido en
28 de febrero de 2022
Número de páginas
6
Escrito en
2021/2022
Tipo
Caso
Profesor(es)
Jean
Grado
A+
$16.99

¿Documento equivocado? Cámbialo gratis Dentro de los 14 días posteriores a la compra y antes de descargarlo, puedes elegir otro documento. Puedes gastar el importe de nuevo.
Escrito por estudiantes que aprobaron
Inmediatamente disponible después del pago
Leer en línea o como PDF

Seller avatar
Los indicadores de reputación están sujetos a la cantidad de artículos vendidos por una tarifa y las reseñas que ha recibido por esos documentos. Hay tres niveles: Bronce, Plata y Oro. Cuanto mayor reputación, más podrás confiar en la calidad del trabajo del vendedor.
lecden
3.9
(75)
Vendido
616
Seguidores
518
Artículos
2966
Última venta
1 semana hace



Por qué los estudiantes eligen Stuvia

Creado por compañeros estudiantes, verificado por reseñas

Calidad en la que puedes confiar: escrito por estudiantes que aprobaron y evaluado por otros que han usado estos resúmenes.

¿No estás satisfecho? Elige otro documento

¡No te preocupes! Puedes elegir directamente otro documento que se ajuste mejor a lo que buscas.

Paga como quieras, empieza a estudiar al instante

Sin suscripción, sin compromisos. Paga como estés acostumbrado con tarjeta de crédito y descarga tu documento PDF inmediatamente.

Student with book image

“Comprado, descargado y aprobado. Así de fácil puede ser.”

Alisha Student

Preguntas frecuentes