Leader: R Simpson
Caulfield T3-58 2005 (Day)
Synopsis: Data processing and databases. Project planning. Three schema architecture. Data as a resource. User requirements. Database logical design. Introduction to data modelling: the E-R diagram. Introduction to the relational model. Physical storage devices. Transaction processing. System maintenance. Addressability. Data structures. Sorting, physical clustering, dense and non-dense indexing. Database administration.Security, Recovery. SQL commands. Data warehousing, Distributed database.
Assessment: Examination (2 hours): 50% + Practical work: 50%
Prohibitions: BUS2112, CFR2132, CFR2201, COT2132, COT2138, COT2180, COT3180, CSC3161, CSE2132, CSE2138, CSE2180, CSE3316, not available to students enrolled in the Bachelor of Network Computing and Graduate Diploma of Network Computing.