{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}


S307_spring10+overall - Data Management(S307 Spring 2010 Tu...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Page 1 of 6 Data Management (S307) Spring 2010 Tu/ Th 2:30p – 3:45p, BU202 Instructor: Vijay Khatri Office Hours: Tu/Th (4:00p - 5:00p) or scheduled appointments Room: BU560F Email: [email protected] Phone: 855-2581 TA/AI : Chad Fritsch ( [email protected] ) Course Website: Oncourse, http://oncourse.iu.edu Text Book (required): Modern Database Management . Jeffrey A. Hoffer, Mary B. Prescott and Heikki Topi. Ninth Edition, Addison Wesley, 2009. Text Book (optional): Oracle 10g Programming: A Primer , Rajshekhar Sunderraman, Addison Wesley, Inc., 2008. Other Database Text Books: Fundamentals of Database Systems . R. Elmasri and S. Navathe. 2006, 5 th edition. Addison-Wesley Publishing Co. An Introduction to Database Systems . C. J. Date. 2003, 8 th Edition. Addison-Wesley Publishing Co. 1. C OURSE O VERVIEW Database management systems are at the heart of modern business information systems. Data management, which focuses on data collection, storage, and retrieval, constitutes a core activity for any organization. Topics covered in this course include conceptual design of database systems using the entity relationship model, relational design and normalization. The focus for this course will be on the relational database model with SQL (Structured Query Language) as a language for creating and manipulating database objects. At the end of the class you should be able to: (i) Understand various aspects of design in the database development lifecycle : Developing conceptual schema (e.g., ER diagrams) based on users’ requirements (conceptual design) Translating the conceptual schemas to relational schemas, also referred to as tables (logical design) Embedding storage and performance related requirements in the design of databases (physical design) Developing and querying a database using SQL (ii) Get cognizant of variety of tools and techniques : Hands-on exercises related to conceptual and logical design Developing and querying tables using SQL (Oracle 10g and MS SQL Server) Undertake a group project that goes through the entire database development lifecycle
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Page 2 of 6 2. A SSIGNMENTS The effective assimilation of the technical course material requires repeated exposure and practice. The homework assignments are designed to encourage students to adopt the habit of working actively with the course material. For some assignments, you may be asked to turn in both hard and soft copies of the assignments. Homework is due at the start of class on the due date. Late homework will not be accepted and will not receive any credit. Some of the homework assignments are related to Oracle Database Management System (DBMS). Assignments in this course require individual attention and effort to be of any benefit; therefore, all work is expected to be that of each student alone, without consultation with others. Any student engaging in or helping another engage in dishonest conduct will be given a failing grade
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}