Database Project

Group Member Contributions         Since our group more all over consisted of two people, we easily stop up the usageload 50/50. We collaborated some(prenominal) times passim the semester to neck up with ideas for what we pauperismed our database to look equal and what functions it would be able to perform. nigh of the germane(predicate) information we mandatory was not learned until afterward in the semester such as: how to halt finalized reports, how to make incontestable the tables were normalized correctly to ensure functionality, and how to conceive the limits of our database. We olfactory property the database is comfortable enough to handle relevant queries, but in no way do we regard we have the have confabulation to implement a signifi placet world database for an out leisurely facility. The die hard was do unitedly so we cannot itemize what all(prenominal) of us did. It was a combine effort. Phase 3: semantic and Physical Domains put over Doctor Docid - is our primary aboriginal that allows for each doctor to be given a eccentric number for the innovation of identification. Dlname - classifies extra doctors by their exist name. Dlfname - classifies specialized doctors by their first name. Dspecialty - Since in the medical field thither are conditions that require give-and-take each doctor is classify by their practicing specialty.

This allows for affected roles to schedule appointments with doctors to work around their area of interrelate so that the best patient care is provided. Table Employee Empid ? Allows for employees to be assigned a unequaled 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 periodical wages of each employee for the purpose of budget projections and payroll information. Emptitle ? gives employees the put-on title they hold which allows for... If you essential to get a full(a) essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper