Abstract
This subject will provide a solid grounding in database design . It will examine the importance of database design in the development of applications that meet business needs. There will be an emphasis on modeling a database using Entity Relationship Diagrams (ERDs), optimising its design using normalisation techniques and implementing … For more content click the Read More button below.
Syllabus
The role of database management systems and their importance to business organisationsThe importance and use of data models to design databases to meet business requirementsThe conceptual design of databases using Entity Relationship DiagramsThe use of normalisation techniques to optimise database designThe implementation of databases using Structured Query Language (SQL)The querying … For more content click the Read More button below.
Learning outcomes
Upon successful completion of this subject, students should:
1.
be able to model complex business rules using Entity Relationship Diagrams (ERDs);
2.
be able to apply normalisation techniques to optimise a database design;
3.
be able to use complex Structured Query Language (SQL) commands to query a database; and
4.
be able to research a recent development in the field of database technology.
Enrolment restrictions
Only available to postgraduate students
Incompatible