Catalog description:
Concepts, approaches, and techniques in database management.
Representation of information as data, data storage techniques,
foundations of logical data models, data retrieval, database design,
transaction management, integrity and security. Pr. 501 and (301
or Math 510).
Line Number: 36550 TH 2:30-3:45 Nichols 127
Log
, Assignments , Resources
Instructor:
William Hankley
email: hankley@cis.ksu.edu
www:
http://www.cis.ksu.edu/~hankley/
Topics:
1. DBMS's: data definition, SQL, constraints, other features;
2. DB design: models, normalization, query structure,
transactions;
3. DB applications: GUI design, db components, EJB's, web access;
Objectives:
Understanding of database system concepts;
working knowledge of SQL, Oracle, and Access;
skill in designing and implementing a DB application;
experience in investigating and reporting topics in DB systems.
Requirements:
Homework assignments:
Access, SQL (several), Java
client+JDBC, Java Web client
2 examinations;
project (design / implemention);
class presentation (slides).
Grading:
A -> upper level on exams and upper level on other work and
A project
B -> middle level on exams or missing homeworks or
B on project
C,D -> low level on exams or missing
several
homeworks or weak / incomplete project
Text :
G.
Riccardi, Principles of DataBase Systems with Internet and Java
Applications,
Addison-Wesley, 2001.
Honesty: Cheating and plagiarism are akin to theft. Such an
act is a step in being a thief.
I Cor. 6:9 Do not be deceived; ...thieves .. shall not inherit the
kingdom of God.
Also, such an act may result in dismissal from the course or from the
University.
end.