Official TCC Course Syllabus
Discipline Prefix: ITD Credit Hours: 4 Contact Hours: 4 Course Number: 260 Course Section: H01B Lecture Hours: 4 Studio Hours: Clinical Hours: Semester: Fall 2014 Lab Hours: Course Title: Database Modeling and Design
Meeting Days/Time/Location: Wednesday, 8:00 pm – 9:40 pm, ATC – H207
Name: John Clary Office Location: ATC – H207 Office Hours: Immediately before and after class, other times and locations by appointment Contact Information: firstname.lastname@example.org Blackboard site: http://learn.vccs.edu
Introduces life cycle application development methodologies in a systematic approach to developing ...view middle of the document...
Measurable Learning Outcomes
• • • • • • • • • • • • • Design a relational database Design and use an ERD (entity relational diagram) Describe and use Star Schemas Describe and use Snowflake Schemas Develop the methods to design a data warehouse Describe the importance of data within an organization Identify the various levels of decision support systems Describe the importance of system modeling Analyze user information requirements to develop data models Design and interpret conceptual data models Develop a relational database design from an entity-relationship model Identify and correct poor database designs Define the SDLC (System Development Life Cycle) as used in an IT environment
Topics Covered in the Course
• • • • • • • Database definitions and terminology Data management concepts Information in organizations CASE tools Design objectives Functional and business process modeling Data modeling (normalization, relationships, ERDs, standards) Page 2 of 8
• • • • • •
Data integrity Data structure and architecture Design methodologies System analysis Data warehousing (multi-dimensional data, OLAP, data mining) Object oriented concepts
Description of Assignments/Assessments
Work will be completed both in class and assigned as homework. Be sure that your work is clearly identified with your name. Computer files should include your name and course in the file name, such as J_Smith_ITD101_Assignment_1.docx. Computer files should be submitted via Blackboard, not by email unless directed otherwise.
The following course schedule may change due to the progression of the course. The course schedule may change at the discretion of the instructor; however, students will be notified in writing when any changes/additions are made to the schedule. The most current information will be posted on Blackboard. • • • • • • • • • • August 25 August 27 September 11 October 8 October 15 October 30 November 26 December 10 December 17 December 19 Fall Semester begins First day of ITD 260 classroom instruction Last day to drop for tuition refund Project 1 due Midterm Exam Last day to withdraw from course without academic penalty Non-instructional day (college closes at 12:00 PM) Project 2 due Final Exam Fall Semester ends
Blackboard and Course Communication
You should check Blackboard and your VCCS (TCC) email accounts frequently. Information on Blackboard is updated often. The Blackboard Learn smartphone app is available in the iTunes and Google Play app stores. Please feel free to ask questions. You are encouraged to use the Help! Discussion board so that others may benefit and participate. I strive to answer email within 24 hours but it may take longer on weekends.
Page 3 of 8
All students are expected to be present and on time at all scheduled class meetings. Instructors are not required to admit a student who arrives late to the classroom. A student who adds a class or registers...