Important Information
Programs
Courses
Residential Schools
International Students
Current Handbook
Glossary
By Course Code:
ACCT AINV ALLH AQUA ARTH ARTS AUDV AVAT BIOH BIOL BIOT BLAR BLCN BLOC BLSV BMED BMSC BOTN BUSN CHEM CHIR CNSL COIS COIT COMM COMT CQUN CREA CULT DGTL DNCE DRMA ECOM ECON EDCU EDEC EDED EDEL EDFE EDHE EDSE EDVT ENAC ENAE ENAG ENAM ENAR ENCO ENEA ENEC ENEE ENEG ENEM ENEP ENEV ENIM ENMG ENML ENMM ENPG ENPO ENRG ENSD ENSE ENTA ENTC ENTE ENTG ENTI ENTM ENTZ ENVH ENVR ESSC EVST FAHE FARM FILM FINC FSEH GENE GEOG GEOH GOVP HIST HLPB HLTH HLTP HMGT HMSC HRMT HUMT IEXC INDG JALC JAPN JAZZ JOUR LAWS LITR LNGC LNGE LOTE MARN MATH MBIO MDWF MEDI MEDS MGMT MMST MNTR MQPR MRKT MUSC NHLT NHPE NURS NUTR OCCT OCHS OLTC ORAL PERF PHRM PHYG PHYS PMSC PODI PPMP PROP PSIO PSYC RAIL RELG SAFE SCIE SKIL SOCL SOWK SPCH SREC STAT SWHS THTR TOUR VART WELF WRIT ZOOLCOIT12167 Database Use and Design
Course details
Relational databases are pervasive in the current society of information technology; designing and building these databases is a challenging and rewarding occupation. This course introduces the student to data modelling, relational database theory and normalisation - essential skills for the design and implementation of relational databases. The problems associated with poorly designed and implemented databases are demonstrated. The important database language SQL is covered in sufficient depth to allow the student to appreciate its potential and limitations. Other topics covered in this course include multi-user database processing, and Internet database applications. During the course, the student will design and implement a small database application using Microsoft Access (or some other product). The course aims to give the student the solid theoretical foundation so essential for working in the field of database design, while also providing an opportunity to apply the theory through the assignment work.
Course at a glance
| Career: | Undergraduate |
| Credit points: | 6 |
| Requisites: | Prerequisite: (COIT 11166 or COIS 12030 or COIT 11136 or COIT11194) and (COIT 11134 or COIT 11135 or COIS 12041 or MMST 11002 or COIT11222) |
| Student Contribution Band: | 2 |
| EFTSL: | 0.12500 |
Course availability
PRINT WARNING - Printed copies of this document or part thereof should not be relied upon as a current reference document. ALWAYS refer to the electronic copy for the latest version.