[마케팅] [마케팅 고객관리] 한마음 약국 고객 관리 데이터베이스 Schema & Query

*
Entity Relationship Diagram
pharmacy
name
Identity number
customer
symptoms
age
name
Gender
Quantity
Making date
Medicine name
Factory
Quantity
Price
Medicine name
Schema & Query
Medicine chart
Medicine name
Making date
Quantity
customer
name
Identity number
symptoms
Factory
Medicine name
Quantity
Price
pharmacy
name
age
Gender
Quantity
symptom
Create table & insert contents
Schema & Query
create table pharmarcy
(name varchar(20) primary key, identitynumber varchar(20) not null, gender varchar(10) not null, age varchar(10) not null, symptom varchar(50) not null, makingdate date not null);
Insert into pharmacy(Name,identitynumber,gender,age,symptom,makingdate)
values(`황성현`,`85x--xx`,`남`,`24`,`감기`…(생략)