The team: Monica, Raluca, Sabina, and Victor Project manager: Carmen Popescu

1. GAMBIT'S The team: • Monica, Raluca, Sabina, and Victor • Project manager: Carmen Popescu Mission Statement: The chess board is the market, the rules of the game are what we call the laws of commerce and there’s no room for mistakes. In our view, investments do not mean sacrifice. They’re the root of progress, and our job is to highlight your company’s ideal moves in its quest for excellence and make them possible. Check and mate.

2. Purposes: • Devising ever more effective and less time-consuming solutions for easy access and easy manipulation of information, our company offers innovative possibilities of reducing expenses, adapting to the ever-increasing requirements of the clients and successfully facing the relentless competition on the market. • Behaving professionally in the modern working environment does not resume to offering perfect services. Gaining more and more control of the company, identifying and destroying the procedural time- and money-consumers and maintaining a "friendly interface" with the clients, associates and employees is essential. A "Gambit’s" database is designed to fit your company perfectly, just as an implant does, and will just do the trick.

3. Business Description: • The "Paltinul " clinic from Sibiu is a modern and significant instance of the local medical private system, offering a broad range of medical services, possessing modern high-quality equipment and employing highly competent personnel. • Such an elegant status urges unceasing improvements, such as storing data within the most efficient, cutting-edge databases, which allow uncomplicated high-speed accessing and querying. • Further advantages of this upgrade are unlimited possibilities to improve the quality of the services provided, to reduce unnecessary costs and to minimize time consumption, caused by imperfections in business procedures and especially in data storage.

4. Business Needs (I): • well organised and stored database: The intricate nature of the company's rules and procedures make the necessity of storing and easily accessing immense amounts of information unquestionable • refreshing and restructuring employee status: The implementation of the database will provide the business with a new vision of the employee structure, eliminate unnecessary staff and reassign tasks for each working person • the “Paltinul “Clinic from Sibiu needs to keep track of all patients, past and present, their medical history, along with all receipts issued at a given time. This simplifies the information storage and access process, thus allowing patients and doctors to save time and money, also it simplifies the process of finding and refreshing one’s information, saving money too

5. Business Needs (II): • our client’s staff is well trained and there is a need to permanently keep track and monitor information regarding salary for each member (employee) • the business’s manager must, at all times, have full access to the database, for quick references, easy alterations and an overall potential of solving all tasks fast, simple and with high reliability, so our mission was also focused on creating a reliable, working database with easy query and alteration possibilities • we need to devise a system that is so easy-to-use and reliable that even the employees that have nothing to do with data modelling can understand and explain it

6. Other conclusions drawn from the interview regarding business rules: • a patient can not benefit from a medical examination without a prior appointment • appointments are scheduled by a registering clerk • information regarding all patients (their medical history, along with all receipts issued at a given time) remain stored within the archives of the clinic

7. Assumptions: • all medical services take place within the confines of the clinic • employees are paid exclusively from the clinic’sbudget • all major credit cards are accepted • the profit of the company is measured on a yearly basis • all paraclinical investigation chambers are located on the same floor

8. ERD: JOB ASSIGNMENT #doctor CNP #medical service code OFFER #code *validity date MEDICAL SERVICE # code *date *price represents belong to STOMATOLOGY #room number *floor number contain the section for represented contained in APPOINTMENT #date *hour EMPLOYEE #CNP *first name *last name *birth date *phone number *sex ¤driver’s license handled by RESULT #name *value represented INDUSTRIAL MEDICINE #room number *floor number be given represents the section for LABORATORY TEST ¤description give PATIENT #CNP *first name *last name *birth date *phone number ¤driver’s license ¤notes in the section of made by ¤ belong to in the section of MEDICAL EXAMINATION *diagnosis ¤ RADILOGY #room number *floor number the section for in the section of ¤ have in the section of ¤ in the section of ¤ result in result in PEDIATRICS #room number *floor number the section for have DOCTOR *specialization be the result of be the result of PAYMENT #code *value *settling date *payment method handle PRESCRIPTION #code ¤description be registered by SUBSCRIBER #subscription code make REGISTERING CLERK *training PARACLINICAL INVESTIGATIONS *floor number guided by guide include NORMAL PAYER #CNP register result in the source of be a part of ELECTRODIOGRAPHY #room number PRESCRIPTION LINE #number *dose DRUG #bar code *name include DAILY SCHEDULE #date #start hour *end hour MANAGER * training INSURED PATIENT #insurance code belong to part of have ULTRASONOGRAPHY #room number the section for covered from EXPENSES #total value have ADMINISTRATOR *training belong to the result of SPIROMETRY #room number MEDICAL RECORD #date *description PROFIT #total value #year REQUIRED MATERIALS *value SALARY *value OTHER paid to managed by AUTOMETRY #room number manage RISK FACTOR *description paid with TAXES *value OTHER *value

9. Notes: • registering clerk - employee in charge of official records, such as appointments and patient records • administrator - employee whose job is to handle finances and employment issues • CNP –personal numeric code, used in Romania for uniquely identifying each citizen • risk factor – information regarding each patient’s family history concerning hereditary diseases • we consider that each customer pays for the services, in one way or another (the Insurance House pays for the insured ones and the subscribers have already paid for their services by subscribing)

10. References: • official site: www.paltinul.afaceri-online.ro • staff members who provided information: • Dr. Elena Schiopu (interviewee) - home address: Intrarea Siretului Str., 6, Sibiu, Romania - phone number: 0722534473 - e-mail: elenaschiopu1980@yahoo.com • Dr. Petre Rotaru