Handbook : Unit informationEdith Cowan University

School: Science

This unit information may be updated and amended immediately prior to semester. To ensure you have the correct outline, please check it again at the beginning of semester.

• Unit Title

  Systems and Database Design

• Unit Code

  CSI5135

• Year

  2016

• Enrolment Period

  1

• Version

  1

• Credit Points

  15

• Full Year Unit

  N

• Mode of Delivery

  On Campus
  Online

---

Description

This unit introduces students to the concepts of relational databases, including database design via normalisation and entity-relationship modelling in order to solve problems. It explores the use of Structured Query Language (SQL) to create, populate and administer relational databases and to perform complex queries upon the data inside them.

Equivalent Rule

Unit was previously coded CSG1207, CSI4341

Learning Outcomes

On completion of this unit students should be able to:

1. Demonstrate an understanding of the fundamental concepts of relational databases and what distinguishes them from other data storage methods.
2. Design complex queries to retrieve data in a relational database using SQL.
3. Design relational databases using normalisation and entity-relationship modelling.
4. Identify the difference between a logical and a physical database design.
5. Use SQL to implement, populate and administer a database design in a relational database management system (RDBMS).

Unit Content

1. Creating and administering databases in SQL.
2. Data manipulation and querying in SQL.
3. Database design using entity-relationship modelling.
4. Database design using normalisation.
5. Introduction to RDBMS technology and SQL.
6. Introduction to database models, concepts, terminology and history.

Additional Learning Experience Information

Lectures & practical workshops, research and group work.

Assessment

GS1 GRADING SCHEMA 1 Used for standard coursework units

Students please note: The marks and grades received by students on assessments may be subject to further moderation. All marks and grades are to be considered provisional until endorsed by the relevant Board of Examiners.

^ Mandatory to Pass

Text References

• Turley, P., & Wood, D. (2009). Beginning T-SQL with microsoft SQL server 2005 and 2008. Indianapolis: Wiley.
• Silberschatz, T., Korth, H. F., & Sudarshan, S. (2010). Database system concepts (6th ed.). New York: McGraw-Hill.
• Pratt, P. J., & Last, M. Z. (2008). A guide to SQL (8th ed.). Mason: Cengage.
• Hoffer, J. A., & McFadden, F. R. (2009). Modern database management (9th ed.). Upper Saddle River: Pearson.
• Coronel, C., Morris, S., & Rob, P. (2011). Database systems: Design, implementation, and management (9th ed.). Australia; United States: Cengage.
• Connolly, T., & Begg, C. E. (2010). Database systems: A practical approach to design, implementation and management (5th ed.). Upper Saddle River: Pearson.

Website References

• Microsoft SQL Server Library http://msdn.microsoft.com/en-us/library/bb545450%28v=MSDN.10%29.aspx

---