Textbook: Database Systems: Design, Implementation and Management; (7th. Edition), by Rob, Peter and Carlos Coronel, Course Technology, 2007.

Week	Chap	Lecture Topic(s)
1	1	Database Systems
2	2	Database Models
3	3	The Relational Database Model
4	7	Introduction to SQL
5, 6	4, 6	Entity-Relationship Modeling
7, 8	5	Normalization
9	7, 8	SQL Queries, Creating Tables and Views in SQL
10	9	Database Design
11	10	Transaction Management and Concurrency
12	12	Distributed Systems
13	13	Data Warehouses, Data Mining
14	14	Databases in E-Commerce, Web Database Design
15	→	Final Exam

1. Understand the advantages and disadvantages of using a database management system rather than conventional filing methods. Ii iii iv ix xi xii
2. Recognize the language of data definition and data manipulation and its importance. Iii iv vii xi
3. Recognize the components of a database model and appreciate how implementation as system may vary from the model. Iii iv vii ix xi xii
4. Understand the factors involved in the transformation of a conceptual design into a logical data base design and to a physical database design. Iii iv vii ix xi xii
5. Appreciate the database administration function. I ii iii iv v ix xi xii
6. Use a database management package including use of a query language. Iii iv vi viii ix

1. Use professional tools to produce software components and documentation. (Technological Literacy Outcome, Transitional Strategy, Active Learning Strategies)
2. Practice analyzing and solving problems using structured analytical techniques. (Technological Literacy Outcome, Active Learning Strategies)
3. Use professionally accepted methods and materials in completion of applications. (Technological Literacy Outcome, Transitional Strategy, Active Learning Strategies)

1. Explain the similarities and differences of hierarchical, network, and relational data models. C D E
2. Perform database normalization. D E
3. Develop Entity-Relationship Models. D E
4. Describe the functions of database administration. E
5. Develop applications using a development tool. D F
6. Define schema and subschema and explain the generic terminology associated with them. B C D E
7. Use a query language. B D E F
8. Implement a database using real-world case studies. A D E F

1. Testing Procedures:
   A minimum of three tests is recommended. Tests will cover material presented in class. Tests are not to be missed without a valid excuse.
   
   
2. Laboratory Expectations:
   Lab attendance is required. Assignments will be given and must be completed and handed in at the designated date and time.
   
   
3. Field Work:   N/A
   
   
4. Other Evaluation Methods:
   Class participation, quizzes and homework will also comprise the final grade for the course.
   
   
5. Grading Scale:

   93 – 100 % of total points possible	A
   88 – 92 % of total points possible	B+
   83 – 87 % of total points possible	B
   78 – 82 % of total points possible	C+
   73 – 77 % of total points possible	C
   65 – 72 % of total points possible	D
   Below 65 % of total points possible	F

1. Attendance Policy:
   Pellissippi State Technical Community College expects students to attend all scheduled instructional activities. As a minimum, students in all courses must be present for at least 75 percent of their scheduled class and laboratory meetings in order to receive credit for the course .
   
   
2. Academic Dishonesty:
   Plagiarism, cheating and other forms of academic dishonesty are prohibited. A student guilty of academic misconduct, either directly or indirectly through participation or assistance, is immediately responsible to the instructor of the class. In addition to other possible disciplinary sanctions that may be imposed through the regular Pellissippi State procedures as a result of academic misconduct, the instructor has the authority to assign an F or a zero for the exercise or examination or to assign an F in the course.
   
   
3. Accommodation for Disabilities:
   If you need accommodations because of a disability, if you have emergency medical information to share, or if you need special arrangements in case the building must be evacuated, please inform the instructor immediately. Please see the instructor privately after class or in his/her office. Students must present a current accommodation plan from a staff member in Services for Students with Disabilities (SSWD) in order to receive accommodations in this course. Services for Students with Disabilities may be contacted by going to Goins 127 or 131 or by phone: 694-6751(Voice/TTY) or 539-7153.
   
   
4. Other:
   1. Plagiarism, cheating, software piracy, non-educational use of computer systems and other forms of academic dishonesty are strictly prohibited. A student caught cheating or infracting specific rules will be given a grade of "F" for the course.
      
      
   2. Make-up exams: All exams are required, and make-ups will be allowed only in the rarest of cases. In the event of an emergency, notification of the instructor must be made in advance.
      
      
   3. It is the student's responsibility to request help from the instructor prior to an assignment's due date.