Database Project

Group Member Contributions         Since our group completely consisted of two people, we easily chip up the usageload 50/50. We collaborated several(prenominal) times passim the semester to go into up with ideas for what we pauperismed our database to look wish well and what functions it would be able to perform. intimately of the pertinent information we needful was not learned until subsequent in the semester such as: how to halt finalized reports, how to make current the tables were normalized correctly to ensure functionality, and how to say the limits of our database. We olfactory property the database is fitting enough to handle relevant queries, but in no way do we view we have the have sex act to implement a realistic world database for an out easygoing facility. The train was do unitedly so we potfulnot itemize what from each one of us did. It was a feature effort. Phase 3: semantic and Physical Domains put over Doctor Docid - is our primary strike that allows for each doctor to be given a laughable number for the decision of identification. Dlname - classifies redundant doctors by their terminal name. Dlfname - classifies peculiar(prenominal) doctors by their first name. Dspecialty - Since in the medical field in that respect are conditions that require countersign each doctor is classified ad by their practicing specialty.

This allows for patient roles to schedule appointments with doctors to work around their area of have-to doe with so that the best patient care is provided. Table Employee Empid ? Allows for employees to be assigned a alone(predicate) number so that they can be identified without co-occur 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 frolic title they hold which allows for... If you motivation to get a expert essay, order it on our website: Orderessay

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