|
| STUDENTS
> Database Systems
|
Database Systems
Note:
Whilst every effort is made to keep the syllabus and assessment records correct
for this course, the precise details must be checked with the lecturer(s).
| Code: | B407 |
| Year: | 2 |
| Prerequisites: | Students are expected to have a strong foundation in personal computing skills. If necessary, students should attend appropriate courses organised by UCL Information Systems (see http://www.ucl.ac.uk/is/training/student/index.htm for details). Students should also have some programming skills |
| Term: | 2 |
| Taught By: | Mike Smith (100%)
|
| Aims: |
To introduce data management and the use of database systems. To
provide an overview of the theory and practice of the use of
databases for handling large volumes of data in an organisational
setting. To understand management of complex distributed data on the
web. This course is for Year 2 of the BSc Information Management, and other non-Computer Science students from other years/programmes as approriate
|
| Learning Outcomes: |
To be able to analyse, design and implement a data management
system. In particular to have a thorough grasp of the theory and
practice of relational database systems.
|
Content:
| Overview | What is a database? Data and metadata |
| Conceptual Modelling | Entities, attributes, associations, functional determination
3-level structure, graphical representation
Normalization
Computed and summary data. Time. Attribute domains. Domain restrictions. |
| Relational Databases | Relational algebra
Relational databases and tables
Query languages. SQL
Query optimisation
Database implementation. SQL DDL
Embedded query. Database connectivity. |
| Database Management Systems | Physical data organisation
File organisation for random access
Database administration. Security. Performance
Controlling concurrent updates. Recovery.
Distributed database management systems |
| Other models | Data warehousing
Object-oriented database systems
Hierarchical and network models |
| Information Systems | Information systems analysis. Workflow. Business Process Reengineering |
| Data on the web | XML, XSL, XPath, DOM
RDF and web metadata
Web fronting databases
XML databases and XQuery
Search engines
Content management |
Method of Instruction:
Lecture presentations.
Assessment:
The course has the following assessment components:
- Written Examination (2.5 hours, 75%)
- Coursework Section (1 piece, 25%)
To pass this course, students must:
- Pass the Written Examination (35% or more)
- Obtain an overall pass mark of 35% for all sections combined
The examination rubric is:
Answer 3 questions out of 5Resources:
An Introduction to Database Systems, Chris Date, Addison Wesley
|
