Database Project

Group Member Contributions         Since our group only consisted of two people, we easily discontinue up the usageload 50/50. We collaborated several times passim the semester to come up with ideas for what we pauperismed our database to look like and what functions it would be able to perform. Most of the relevant information we needed was not learned until later in the semester such as: how to halt finalized reports, how to make sure the tables were normalized correctly to ensure functionality, and how to understand the limits of our database. We olfactory property the database is sufficient enough to handle relevant queries, but in no way do we believe we have the have intercourse to implement a real world database for an out unhurried facility. The work was do together so we cannot itemize what each of us did. It was a combined effort.

Phase 3: Semantic and Physical Domains put over Doctor Docid - is our primary key that allows for each doctor to be given a droll number for the purpose of identification.

Dlname - classifies special doctors by their last name.

Dlfname - classifies specific doctors by their first name.

Dspecialty - Since in the medical field there are conditions that require discussion each doctor is classified by their practicing specialty.



This allows for patients to schedule appointments with doctors to work around their area of concern so that the best patient care is provided.

Table Employee Empid ? Allows for employees to be assigned a unique number so that they can be identified without coincide identities.

Emplname ? classifies each employee by their last name Empfname ? classifies each employee by their first name Empsalary ? gives the hourly wages of each employee for the purpose of budget projections and payroll information.

Emptitle ? gives employees the job title they hold which allows for...

If you want to get a full essay, order it on our website: Orderessay



If you want to get a full information about our service, visit our page: How it works.