Uwi Research Database Assignment

Department of Geomatics Engineering and Land Management

Certificate Programme in Geographic and Land Information Systems Management

Objectives of the Programme
  • To enhance the capability of participants in the development and use of GIS/LIS concepts and technology.
  • To provide participants with the working knowledge required in the acquisition, preparation and management of geospatial data.
  • To develop a core of trained GIS/LIS personnel who can provide support for GIS/LIS projects throughout the Caribbean.
Target Groups
  • Those engaged in GIS/LIS development and implementation in both the public and private sectors.
  • Professionals - surveyors, engineers, planners, geographers, agriculturists and all others who are interested in the use, development, and management of GIS/LIS.
Conditions for Entry
  • Passes in at least five (5) O level GCE/CXC subjects, including English Language and Mathematics or an equivalent qualification.
  • Applicants must also be computer literate, as knowledge of MS Windows operating system will be required.
  • Preference shall be given to matured applicants already employed in related fields.
Length of the Programme

This certificate programme will be offered over one calendar year, using a mix of part-time and full-time studies. Each candidate is expected to register and pass a total of seven courses in order to be awarded the certificate.

Nature of Instruction

The programme will be delivered using a series of short, intensive, instructional periods. It will comprise of six, one-week modules of lectures, tutorials and demonstrations, at the end of which there would be a four-week project module.

Components of the Programme
Course Code Course Title No. of Credits Contact Hrs
GLIS 0411Introduction to GIS/LIS339
GLIS 0442Database Design and Development339
GLIS 0482 Feature Extraction from Satellite Imagery339
GLIS 0492Data Acquisition Using GPS339
GLIS 0453Spatial Analysis339
GLIS 0421Digital Cartography and Visualization339
GLIS 0473Special Project678
  24 Credits 312 hours
Nature of Assessment

With the exception of GLIS 0473, which shall be assessed as a 100% coursework, all other courses shall be assessed as follows:

  • Final examination: 70% and assessed assignments: 30%.
  • The following table provides the specific details for each course.
Course Code Course Title Final Exams Course Work Course Work Details
GLIS 0411Introduction to GIS/LIS70%30%Two laboratory exercises 10% each (Total 20%). A report involving assessment of GIS in Trinidad and Tobago (10%)
GLIS 0442Database Design and Development70%30%Two laboratory exercises and reports involving development of databases design and management (15% each)
GLIS 0482 Feature Extraction from Satellite Imagery70%30%Two laboratory exercises and reports involving satellite image processing (15% each)
GLIS 0492Data Acquisition Using GPS70%30%Two laboratory exercises in data acquisition 10% each (Total 20%). A report on the assessment of data acquisition systems (10%)
GLIS 0453Spatial Analysis70%30%Two computer exercises and reports on spatial analysis (15% each)
GLIS 0421Digital Cartography and Visualization70%30%Two laboratory exercises 10% each (Total 20%). A report on the assessment of developments in cartography (10%
GLIS 0473Special Project 100%One technical report based on an approved supervised project
Course Outline
Books
Course Team and Examiners
  • Prof. Jacob Opadeyi (Coordinator)
  • Dr. Raid Al-Tahir
  • Dr. Charisse Griffith-Charles
  • Dr. Dexter Davis
  • Mr. Ron Mahabir

INFO2415 Enterprise Database Systems

COURSE CODE:       INFO 2415

COURSE TITLE:      Enterprise Database Systems

CREDITS:                    4

LEVEL:                         2

PRE-REQUISITES: INFO1506

COURSE DESCRIPTION:

The course covers the design, implementation and management of Database Systems. Emphasis is placed on database design of real world business applications using Entity-Relationship modeling. SQL programming is covered in detail. Query Optimization concepts are introduced in the context of database performance tuning. Data Management concepts such as Transaction Management, Concurrency Control, Recovery, and Security are discussed. Several current database environments and applications including Distributed Databases and Web-enabled Databases are discussed.

COURSE RATIONALE:

Databases are incredibly prevalent; they are a crucial component of telecommunication systems, banking systems or any electronic device that maintains persistent information. Databases also provide reliability and efficiency which makes it an important tool which information technology science students must become familiar with.

CONTENT:

1. Introduction to Database Systems

  • Database / File-based systems; DBMS Functions; Components of a Relational database System; Introduction to Database Design

2. The Relational Data Model –Relational Data Objects, Data Integrity, and Relational Operators

3. Structured Query Language

  • Data Definition commands; Data Manipulation commands; Views; Privileges and Roles
  • Triggers and Stored Procedures

4. Database design

  • ER Modeling; Functional Dependency and NormalizationTransaction Management
  • Transaction processing concepts; Concurrency Control; Recovery; Security

5. Query Processing and Optimization (Performance Tuning)

6. Steps in Processing an SQL query; Cost-based Query Optimization

7. Databases and the Internet – Web technology and Databases; ODBC/JDBC; XML and databases

8. Distributed databases – Distributed database design; Fragmentation and Replication

9. Database Administration – Managerial functions; Technical functions

LEARNING OUTCOMES:

At the end of this course, students should be able to:

  • Identify the practical aspects of database design and be able to use data modeling tools. They will develop real and useful design skills.
  • Explain Structured Query Language (SQL) and use it to implement and manage databases. 
  • Explain how databases are affected by real-world transactions, including the characteristics of database transactions and how they affect database integrity and consistency. 
  • Design Distributed Database Systems and describe the performance, availability and integrity issues involved.
  • Describe the architecture of a database driven web site and how the middleware components facilitate dynamic web pages.
  • Explain the managerial and technical roles of a Database Administrator.

ASSESSMENT:

Method of Evaluation

Percentage of Grade

Restriction

Coursework

       3Assignments (21%)

( case studies and design problems)

 

       1 1-hr written exam (10%)

 

       1 2-hr Practical exam (9%)

 

40 %

 

Final Examination

     One 2-hours written paper

     (Covers entire course – all           

       lectures, readings and  

       tutorials.)

 

60%

Fail Theory Regulation

Students must get a passing grade on final examination to pass the course.

TEACHING STRATEGIES:

The course is delivered using a combination of lectures; practical lab sessions and online activities delivered using the myElearning system such as forum discussions and online quizzes.

RESOURCES:

Rob, P. and C. M. Coronel. 2006. Database Systems: Design, Implementation & Management.  Boston : Course Technology.

COURSE CALENDAR:

TIME PERIOD

TOPIC

WEEK 1

Introduction to Databases; Lab 1 – Introduction to Oracle and SQL

WEEK 2

The Relational Model; Lab 2 – Data Definition

WEEK 3

Database Design – ER Modeling; Lab 3 – Queries involving two tables

WEEK 3

Assignment 1

WEEK 4

Database Design – ER Modeling; Lab 4 – Views

WEEK 5

Database Design – Normalization; Assignment 2

WEEK 6

Theory Exam

WEEK 6

Databases and XML; Lab 5 – XML

WEEK 7

Transaction Management

WEEK 8

Assignment 3

WEEK 8-9

Query Processing Assignment

WEEK 10

Databases and the Internet

WEEK 10

Practical Exam

 

WEEK 11

Distributed databases

WEEK 12

Database Administration

WEEK 13

Revision

Categories: 1

0 Replies to “Uwi Research Database Assignment”

Leave a comment

L'indirizzo email non verrĂ  pubblicato. I campi obbligatori sono contrassegnati *