CSCI2140

Data and Knowledge Fundamentals

 

Syllabus
Assignments
Project
Announcement

 

Lecture Time:            Monday and Friday 11:05am – 12.25pm

Lecture Venue:           LSC Common Area C244

Instructor:                  Raza Abidi

Office Hours:             Wed. 1 pm – 4 pm (or by appointment)

Office:                         Room 214, Computer Science Building

E-mail:                        sraza@cs.dal.ca

Telephone:                 (902) 494-2129

Course website:         http://www.cs.dal.ca/~sraza/CSCI2140.htm

 

Course Objectives

The objectives of this course are twofold: (a) Introduce students to the fundamentals of data management leading towards the design and development of database systems; and (b) Introduce students to the fundamentals of knowledge-based problem solving, leading towards artificial intelligence search techniques used to develop intelligent systems.

In essence, this course attempts to introduce concepts related to the abstraction/transition of ‘raw’ data to ‘useful’ information to ‘decision-support’ knowledge (as shown in the below diagram).

Course Description

This is an entry-level course regarding concepts related to database and intelligent systems. The introductory concepts presented during this course can be studied in more detail in advance courses at the third and fourth year level.

In line with the course objectives, this course is divided into two interrelated sections:

[1]     data fundamentals section deals with issues pertaining to database design and development, such as database systems, relational data model, entity-relationship modelling, data normalization, and database programming languages—Sequential Query Language (SQL)

[2]     knowledge fundamentals section includes topics related to the representation knowledge such as propositional and predicate calculus, search strategies and automated reasoning strategies. An introduction to Prolog (an AI programming language) will be provided.

The first half of the course will comprise lectures on data fundamentals, and will conclude with a mid-term test covering all data fundamental topics. The second half of the course will deal with knowledge fundamentals, and will conclude with a final exam that will comprise questions on all knowledge fundamental topics. A detailed description of the topics, for each section, covered during this course can be found in the syllabus document.

Suggested Textbooks

  1. The Essence of Databases by FD Rolland, Prentice Hall.  

  2. The Essence of Artificial Intelligence by A. Cawsey, Prentice Hall.

C0urse Evaluation Scheme

Course assessment will be based on the following components, each with an attached weight. At the end of the term, the weighted marks for each component will be linearly accumulated to give the total marks (out of 100) which will be translated into the final letter grade using the standard grade conversion table.

Component

Weight
Logistics

Assignments (6 in total)

18 %

 

Due Date: To be specified with the assignment.

Submission: In the class.

Database Project

15 %

To be notified via the course website

Mid-term test

(Duration of 2 hours)

The test will be given one week after the completion of the data fundamentals section

33.5 %

Tentative Date: June 21, 2006.

 

Location: In the class.

Final exam

(Duration 2 hours)

33.5 %

Tentative Date: July 24, 2006

 

Location:  In the class

 

1. Final Exam: The final exam will cover all topics pertaining to the knowledge fundamentals section only. The final exam format will be as follows:

bullet

Multiple Choice Questions (MCQs) to test the conceptual understanding of the subject. I find this style of questioning to be a more accurate and objective reflection of the student’s understanding of the subject, as opposed to ask students to regurgitate text material and write essay-type answers. Negative marking will be applied to MCQs.

bullet

Analytical, problem-solving questions based on techniques covered during the lectures. You should bring your calculators for such questions.

bullet

Short answer questions designed to make you think, analyze and co-relate the various topics covered in the course in order to make an informed answer. Such questions can be answered within 5-8 lines.

 

2. Mid-Term Test: The mid-term test will cover all topics pertaining to the data fundamentals section. The format of the mid-term test will be similar to that of the final exam format (given above).

 

3. Assignments: There will be a maximum of 6 assignments. Students are expected to individually attempt ALL assignments. There will be assignments for both the sections of this course (see the schedule in the syllabus)

(a)   Data fundamentals section

bullet

The assignments are designed from the review and exercise questions given at the conclusion of each chapter in the text book.

bullet

The assignments largely focus on analysis and design related problems.

bullet

Each assignment will be given only after the topics pertaining to an assignment have been discussed by the instructor in the class.

(b)   Knowledge fundamentals section

The assignments require students to exercise selected problem-solving techniques covered during the lectures.

 

Assignment Marking Scheme: I have devised an interesting assignment marking scheme that you will find to maximize the impact of your best assignment result and minimize the impact of your worst assignment result. The marking scheme is as follows:

Each assignment will be worth 100 marks.

At the end of the term, all your assignments will be ranked based on the marks you score for each assignment.

A weighted contribution of each assignment towards the final grade will be determined based on the following table.  

No.

Ranking

Weight %

1

1st (Highest)

20

2

2nd

18

3

3rd

17

4

4th

16

5

5th

15

6 6th (Lowest)

14

Total

 

100%

 

4. Project: The project will be about an applied perspective to database systems, requiring students to use any DBMS system of their choice and work with SQL to design a simple database system. Details of the project will be made available later at the course website (see project sidebar).

 C0urse Regulations

bullet

Students are advised to be fully aware of the Faculty’s Plagiarism Policy. Every suspected case of plagiarism will be referred to the Senate Discipline committee, and the standard penalty for a first offence is failure in the course.

bullet

Students are strongly advised to TURN-OFF their cellular phones and pagers during lectures—under no circumstances they should not ring during a lecture.

bullet

Students are expected to attend each lecture. In case you miss a lecture, it is your responsibility to find out about the proceedings of that particular lecture from your class-mates and act accordingly.

bullet

 Assignments and announcements will be posted on the course website. It is the student’s responsibility to routinely check the course website for assignments and announcements.

bullet

Students should properly submit their assignments, i.e. staple all loose pages. Loss of marks due to missing pages cannot be rectified at a later stage by producing the missing material. Each assignment should have the following information: Name, Banner Id, Course Id, Assignment Number, Date and Email contact.

bullet

 Students can meet me in my office during my office hours. To meet me outside office hours you need to make an appointment either by email, phone or in person. 

bullet

The assignments and project will be graded by a designated marker. If you are not satisfied with the marks, you may contact the marker and explain your point/answer. The marker may try to re-examine your assignment in view of your explanation. However, you are discouraged to routinely approach the marker after each assignment as it may reflect adversely. If you are still unsatisfied than contact the instructor.

bullet

 Make-Up Test Policy: There will be no make-up test. However, exemption will be given to students who were either sick or involved in an emergency situation (such as the loss of a loved one) on the test day. The possibility of a make-up test is subject to the production of (a) letter from a physician detailing the student’s inability to take the test; or (b) evidence of an emergency situation. The make-up test may not necessarily follow the test format given above.

bullet

  Assignment Late Policy: All assignments are expected to be submitted on time right after the lecture on the specified due date. A grace period of 1 hour after the lecture is provided, after which the assignment will be declared as being late (even if it is submitted on the due date). Late submission will be penalized as per the below late assignment submission penalty scheme. The maximum late submission allowance is 3 days (including the due date), after which the assignment will not be accepted for evaluation.

Assignment Submission Schedule

Late Submission Penalty Scheme

In-Time Submission Window

Late Submission Window 1

Penalty -10%

Late Submission Window 2

Penalty -20%

Late Submission Window 3

Penalty -30%

Late Submission Window

Penalty -100%

Monday   1.00 pm

> Mon. 1.00 pm

&

< Mon. 4 pm

> Mon. 4 pm

&

< Tue. 10.30 am

> Tue. 10.30 pm

&

< Tue. 4 pm

> Tue.4 pm

 

bullet

After 2 late assignment submissions, the student will be required to provide an explanation for each subsequent late assignment submission. And, the late assignment submission penalty will be increased to: –12.5%, -22.5% and –32.5% for window 1, window 2 and window 3, respectively (instead of the standard –10%, -20% and –30%).

bullet

 If you are unable to submit on time due to illness or an emergency situation than you need to inform me with proof of illness or emergency. No make-up assignment will be given, rather the submission deadline will be extended.

bullet

The mid-term test and the final exam are both "closed book". However, you may bring ONE Single-Sided 8.5 x 11 inch reference page containing material of your choice. The reference page should have your name and banner id on it and should be typed using a font not less than 12 points. No handwritten notes will be allowed.

bullet

 

 

     

 Home | Up | CSCI2140 | CSCI3140 | CSCI6507 | HINF6210 | HINF6230

This site was last updated 05/04/06