ThisCourseisdesignedtoaddresstheneedsofthestudentundertakingBiomedicalEngineeringin databasesystems. CourseObjectives1. Tointroducethestudenttothefundamentalconceptsofdatamodels2. Toexposethestudenttothemethodsandtechniquesappropriateforagivenproblem3. Tointroducethestudenttotheselectionandimplementationofappropriatedatabasesolutions thatreflectallsuitableconstraints,includingscalabilityandusability.
Oncompletionofthiscoursethestudentwillbeableto:1. Identifysomecontributorstodatabasesystemsandrelatetheirachievementstotheknowledge area,explainhowknowledgediffersfrominformation anddata,anddescribehowcomputer engineeringusesorbenefitsfromdatabasesystemsandinformationmanagement.2. Explainthecharacteristicsthatdistinguishthedatabaseapproachfromthetraditionalapproachof programming withdatafiles,citethebasicgoals,functions,models,components, applications, andsocialimpactofdatamanagementsystems,describethecomponentsofadatabasesystem andgiveexamplesoftheiruseanduseaquerylanguagetoelicitinformationfromadatabase.3. Categorizedatamodelsbasedonthetypesofconceptsthattheyprovidetodescribethedatabase structureandcompareandcontrastthebasicprinciples oftherelational datamodelandthoseof theobject-orientedmodelastheyapplytocomputerengineeringapplications.4. Preparearelationalschemafromaconceptualmodeldevelopedusingtheentity-relationship model, explain and demonstrate the concepts of entity integrity constraint and referential integrity constraintand demonstratethe successfulformulationof queries in the relational algebraandqueriesinthetuplerelationalcalculus