week01.ppt

RELATIONAL DATABASECOT2180  A subject in The Bachelor of Information Management Degree Relational Database I’m : Rod Simpson My Office Location is : C 4.46 Caulfield Campus My phone number is : (32352 for internals) My School : Computer Science and Software Engineering My Faculty is : Information Technology My email address is : rod.simpson@csse.monash.edu.au Lectures for COT2180 will run on Wednesdays from 11.00am to 1.00pm Laboratory sessions will be Wednesdays from 1 to 2, 2 to 3 and 3 to 4pm. (more information to follow) I will be on campus in a room and building(as yet unknown) for consulting on Tuesdays from 1.30pm to 3.30pm. There is 1 assignment (project). You will work in groups of 3 to 4 people - which might be stretched to 5 (see material distributed) The assignment is worth 50% of the subject marks The examination will be closed book. It will consist of 3 sections: A: A number of multi choice questions B: A number of short answer questions including some minor calculations C: One essay type question (choice of 3) and the completion of an Entity Relationship Diagram and Data Structure Diagram Relational Database You should have a copy of the subject outline, which includes the reference to the recommended text (McFadden, Hoffer and Prescott Edition 5) the assignment the Certificate of Work Performed the tutorial guide Lecture notes will be on the Monash Web Site - not finalised yet. Relational Database Relational Database Objectives of this lecture are To introduce you (gradually) to some of the terminology associated with databases some of the concepts of database database management systems (or software) the wide environment covered by the term ‘database’ some of the software components of a DBMS and their purpose a brief introduction to other database mode