CPS352'–!Database'Systems'–!Syllabus(–!Fall$2012"Professor:(Simon(Miner(Fall(Semester(2012(Contact:([email protected](978?380?2626(KOSC(243(Thursday(6:00(–(9:00(pm(–(KOSC(128(Office(Hours:(Thursday(4:00(–(6:00(pm(and(by(appointment(Blackboard(course(site(+(http://www.cs.gordon.edu/courses/cps352((Catalog'Description'Explores(database(technology;(various(data(models,(query(languages,(and(application(program?(DBMS(interface.(Prerequisites:(CPS122,(CPS221,(and(MAT230.(Course'Objectives'In(general,(this(course(is(designed(to(introduce(you(to(basic(database(management(system(concepts(and(applications.((In(particular,(upon(completion(of(this(course,(you(should(be(familiar(with:((1. The(major(data(models((especially(entity?relationship(and(relational),(pl us(new(directions(involving(“NoSQL”(persistence(models.(2. The(use(of(SQL.(3. Design(and(normalization(principles(for(relational(databases,(including(the(various(normal(forms.(4. Underlying(file(structures(used(to(implement(databases,(and(their(performance(implications.(5. Multi?user(database(concerns(such(as(crash(recovery,(concurrency(control,(security,(and(integrity.((6. Various(applications(of(database(systems.(Course'Texts'and'Resources'Silberschatz,(Abraham,(Henry(F.(Korth(and(S.(Sudarshan.((Database'System'Concepts'(6th'ed.).((New(York:(McGraw?Hill,(2011).((Sadalage,(Pramad(J.(and(Martin(Fowler.(NoSQL'Distilled:'A'Brief'Guide'to'the'Emerging'World'of'Polyglot'Persistence.'(Addison?Wesley:(2012).((AVAILABLE'ONLINE:(Selected(tutorial(material(on(SQL(as(well(as(documentation(for(the(database(system(used(for(homework(and(projects(will(be(accessible(from(the(Blackboard(site.(Course'Techniques'and'Procedures'This(is(a(survey(course,(in(which(we(will(attempt(to(gain(a(general(familiarity(with(a(large(volume(of(material.((For(this(reason,(textbook(reading(and(problem(sets(will(play(a(significant(role(in(the(course,(with(a(somewhat(reduced(emphasis(on(actual(programming.(((Homework(exercises(and(two(projects((one(a(design(project(and(one(a(programming(project(using(commercial(DBMS(software)(will(provide(an(opportunity(for(you(to(gain(familiarity(with(practical(application(of(the(theoretical(material.(((Course'Requirements'and'Evaluation'1. You(will(be(expected(to(read(most(of(the(textbooks,(as(assigned(in(the(topic(schedule(below.((Reading(assignments(should(be(completed(BEFORE(the(class(session(in(which(the(topic(is(discussed.((2. Seven((7)(homework(sets(will(be(distributed(during(the(semester(and(will(be(due(as(shown(in(the(course(schedule.((These(will(consist(mostly(of(selected(problems(from(the(texts,(plus(exercises(using(online(database(tools.((All(told,(these(will(account(for(30%(of(the(final(course(grade.(('Set'Number'Tentative'Emphases'(1(Fundamental(Concepts;(The(Relational(Model;(Relational(Algebra((2(SQL((3(Relational(Database(Design(and(Normalization((4(Database(Application(Development;(DBMS(File(Structures;(Indexes;(Efficient(Query(Processing/Optimization((5(Transactions;(Concurrency;(Crash(Recovery((6(Database(Architectures;(Parallel(and(Distributed(Databases((7(NoSQL((The(following(guidelines(should(be(observed(when(doing(these(homework(sets:((• Homework(sets(will(be(due(at(the(start(of(class(on(the(date(indicated.(Late(homework(sets(will(NOT(be(accepted.(• Homework(sets(must(be(done(on(one(side(only(of(8?1/2(x(11(paper,(and(pages(must(be(stapled(in(problem?number(order.((Problems(must(be(numbered,(and(final(answers((where(appropriate)(should(be(highlighted.((Homework(sets(not(conforming(to(these(standards(will(be(returned(ungraded.)(• You(may(work(together(with(another(student(on(homework,(provided(each(of(you(works(on(each(problem.(• Where(an(exercise(calls(for(writing(a(program,(it(is(sufficient(to(write(it(out(by(hand;(you(need(not(enter(it(into(the(computer.((3. Structured(Query(Language((SQL)(is(the(standard(language(for(querying(relational(da tabases.(For(this(reason,(it(is(important(that(you(become(thoroughly(familiar(and(comfortable(with(using(SQL.((Most(homework(sets(will(include(several(questions(that(can(be(answered(by(performing(a(query(on(an(example(database;(you(will(be(required(to(turn(in(the(queries(and(the(answers(that(you(got(from(them(as(part(of(the(homework.((Learning(how(to(formulate(the(required(queries(may(require(some(searching(of(relevant(SQL(tutorial(resources.((4. During(the(semester,(you(will(apply(the(material(you(are(learning(to(a(project(in(which(you(will(design(a(database(application(of(your(own(choice,(requiring(on(the(order(of(a(dozen(tables.((((You(will(be(responsible(for(turning(in((1)(a(description(of(the(requirements(for(this(system;((2)(an(E?R(diagram;(and((3)(an(actual(database(with(simulated(data.((((You(are(not(responsible(for(building(the(application(?(only(for(designing(the(database(for(it.)(((Specific(requirements(for(the(project(will(be(distributed(in(class.((All(parts(of(this(project,(together,(will(be(worth(20%(of(the(final(course(grade.( 5. You(will(complete(a(major(programming(project(involving(the(development(of(a(DBMS(application(using(a(database(design(furnished(by(the(instructor.(((Specific(requirements(will(be(distributed(in(class.((This(project(will(be(w ort h(15%(of(t he(final(grade.(6. There(will(be(two(take?home(examinations((a(midterm(and(a(final(exam)(given(as(shown(in(the(course(schedule(below.((The(midterm(exam(will(account(for(15%(of(the(final(course(grade,(and(the(final(exam(will(account(for(20%((for(a(total(of(35%).(Exams(will(be(open(book,(open(notes.( 7. SUMMARY:( 7(Homework(sets( ( ( ((30%(( Database(design(project( ((20%(( Programming(project(( ((15%(( Exams( ((35%(( ( 100%((8. Your(final(grade(will(be(computed(on(the(basis(of(a(weighted(sum(of(the(items(listed(above.(((The(following(are(the(minimum(guaranteed(grades(for(the(percentages(indicated:(((93%(?(100%:(A(90%(?(92.9%:(A?(87%(?(89.9%:(B+(83%(?(86.9%:(B(80%(?(82.9%:(B?(77%(?(79.9%:(C+(73%(?(76.9%:(C(70%(?(72.9%:(C?(67%(?(69.9%:(D+(63%(?(66.9%:(D(60%(?(62.9%:(D?(Policy'Statement'on'Extensions'and'Incompletes'1. Extensions(of(the(due(dates(for(homework(or(projects(will(be(given(in(the(event(of(extenuating(circumstances((such(as(illness,(personal(emergency,(etc.)((IF(you(submit(a(brief(written(request(to(the(professor(as(soon(as(possible(after(the(circumstances(arise.((This(request(will(be(initialed((if(approved)(and(will(be(returned(to(you.((You(must(attach(it(to(the(piece(of(work(for(which(the(extension(was(granted.((2.
View Full Document