IT 350

Catalog Data: (3:2:3) W Prerequisite: CS 235.
Database theory and architecture. Data modeling and designing application databases. Query languages, data security, client server and shared flat file, enterprise database applications

Textbook(s):

• Riccardi Greg, Principles of Database Systems with Internet and Java Applications, Addison-Wesley 2001

Recommended Book(s):

• Date, C.J. An Introduction to Database Systems,Addison-Wesley 2000

Reference Book(s):

• Carlis, John, Maguire, Joseph, Mastering Data Modeling, Addison Wesley 2001
• Bowman, Judith S., Emerson, Sandra L., Darnovsky, Marcy, The Practical SQL Handbook, Addison-Wesley 2001

Class website: http://class.et.byu.edu/eit350/

Class Coordinator: Stephen Renshaw

Goals: At the completion of this class the students should be able to do the following:
1. Use data modeling methods to model real world systems.
2. Understand and set up database schemas.
3. Use SQL for both database setup and report generation.
4. Understand and be able to program databases for web systems.

Prerequisites by topic:

• High level language (HLL) programming experience.
• Binary and Hex number systems and math.
• Understanding of HLL data structures.

Outcomes

1. Use data modeling methods to model real world systems
2. Understand and set up database schemas.
3. Use SQL for database setup and report generation.
4. Understand and program database access for web systems.
5. Understand and use Java to implement web systems.
6. Understand and use Java components (Servelets,JSTL, JSP)
7. Recognize normal form violations given a set of relations and a set of functional dependencies.
8. Restructure relations to remove normal form violations.
9. Understand how putting relations in normal forms reduces redundancy and update/delete anomalies.
10. Describe how J2EE component architecture creates the possibility of a marketplace for enterprise system components.
11. Understand the relationship between data and information.
12. Do research into current DB topics for life-long learning
13. Write technical (lab) reports to meet technical writing standards

Laboratory projects: The laboratory projects give the students experiences in both desktop database systems and client server database systems. The students also get experiences with web based database access.
The main lab room is 375 CTB.

Laboratory topics (topics do not necessarily correspond to individual lab exercises):

• Introduction to Microsoft Access
• Relational Modeling (Using real world situation)
• Implementing Model in Access (Using real world situation)
• Loading and configuring Client server databases (MySQL)
• Introduction to SQL programming
• Introduction to PHP programming
• Personal project schema
• Personal project build and populate
• Personal project, database generated reports

Laboratory Equipment:

1. Microsoft Access
2. MySQL database software on Linux
3. PHP scripting language
4. Apache web server on Linux

Computer Equipment: The majority of the labs will be done on Intel based computers.(808X type). Windows and Linux will be used for various database experiences.

Written and oral communication requirements: Four periodical article readings in database technology are required with a one-page write up on each.
Lab reports are required for each lab session, which are complete lab write-ups.
Class portfolio turned in at completion of semester includes all work for the class.

Math Analysis: Algebra used for Relational Algebra.

Library or other Research Projects: Report on current news article in operating systems field. (see below)

Life-long learning experiences: As mentioned previously, this class requires that students engage in outside reading (in technical periodicals) and submit reports based on this reading.

Prepared By: S Renshaw

Date Revised: May 2005