[마케팅] [마케팅 고객관리] 한마음 약국 고객 관리 데이터베이스 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`,`감기`,`07.12.24`); . . . insert into pharmacy(Name,identitynumber,gender,age,symptom,makingdate) values(`한가인`,`9x--xx`,`여`,`19`,`폐암`,`08.03.11`); Customer table Pharmacy table Medicine chart table Factory table Schema & Query * Search of data S…
…