Transcript Introduction - Mark Dixon`s web site

SOFT 139
01 – Module Introduction
Mark Dixon
Page 1
About Me
• Contact Details
Mark Dixon
[email protected]
01752 232556
Portland Square
Room B316
• Availability
Mon, Tue, Wed, Thu – School of Computing Communications
and Electronics (main campus)
Fri – other work (usually off-campus)
Mark Dixon
Page 2
Module Aims
• This module aims to teach you, how to:
– learn (self-directed)
• surface learning (memorisation of isolated facts): hacking
• deep learning (interrelated concepts)
• includes interacting with others (lecturers, students, …)
– create databases:
• fundamental concepts (e.g. table, field)
• how to combine these to solve problems
– use Microsoft Access
Mark Dixon
Page 3
Module Admin
• Lectures and tutorials:
– start at 5 minutes past the hour, and
– aim to end at 5 minutes to the hour
– if no lecturer - wait until 15 minutes past the hour then you
may leave
– Turn mobile phones off.
– Ask questions or comment at any time
– Feel free to talk quietly amongst yourselves
– Material (slides, handouts, etc.) available before session,
on: web-site (mdixon.soc.plymouth.ac.uk)
• Lectures:
– Don’t come in after 15 minutes past the hour.
Mark Dixon
Page 4
Module Format
The module is delivered as follows:
• Lecture/Tutorial: 1 hr per week, Tuesdays 11:05 –
12:55
• Private study (as much as it takes – typically 3
hours/week)
• 1 to 1 sessions (my office or labs) as needed at your
request
• Teaching Evaluation (timely and specific)
– Student Perception Questionnaire
– Continuous Informal Feedback (talk to me)
Mark Dixon
Page 5
Schedule (subject to change)
Week
1
2
3
4
5
6
7
8
9
10
Date
8 Jan
15 Jan
22 Jan
29 Jan
5 Feb
12 Feb
19 Feb
26 Feb
4 Mar
11 Mar
11
12
8 Apr
15 Apr
Mark Dixon
Title
Introduction
Queries
SQL
Multiple Tables
SQL 2
Database Design
Forms
In-class Test
Data Integrity
Forms 2
Easter
Web pages
Web pages 2
Content
Creating a database, creating a table with fields and records.
Query by example
SELECT, FROM WHERE, ORDER BY
Creating multiple tables, Primary key, Foreign key
GROUP BY Joins
Normalisation
Controls, properties
Multiple tables
Page 6
Attendance
• Attendance is compulsory
and essential to pass
• This is not a distance learning course
• web-site is supplement (not
replacement) for attending lectures
and tutorials
Mark Dixon
Page 7
Mark Dixon
Page 8
Example: People (Database)
• Information organised into
– tables (e.g. person)
– fields (e.g. phone)
– records (e.g. 1 Dixon Mark 01752 232556 …)
Person
ID
1
2
3
4
5
Surname
Dixon
Smith
Jones
Bloggs
Johnson
Mark Dixon
Field
Record
Forenames
Mark
John
Sally
Fred
Genny
Phone
01752 232556
01752 111111
01752 888888
01752 123123
01752 987987
email
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
Page 9
Example: Music (Database)
• How many fields?
• How many records?
Track
Mark Dixon
Track Title
Artist Name
Country
Paranoid
Black Sabbath
UK
Falling in Love
Aerosmith
US
Pink
Aerosmith
US
Love in an Elevator
Aerosmith
US
Smooth Criminal
Alien Ant Farm
US
Meaning of Life
Disturbed
US
The Game
Disturbed
US
Voices
Disturbed
US
Down with the Sickness
Disturbed
US
Page 10
Database Management Systems
• DBMS provides facilities for:
– creating and changing databases
• add/remove records
• add/remove fields
• add/remove data
– For example:
•
•
•
•
•
•
Mark Dixon
Microsoft Access
dBase
Borland Paradox
MySQL
Microsoft SQL Server
Oracle
home/small business
large scale
Page 11
Tutorial Exercise 1: Music database
• LEARNING OBJECTIVE:
to understand table, field, and record,
so that you can create your own database with
a single table containing several fields and records
using MS Access
• TASK: Create the music database (shown in earlier slide).
Mark Dixon
Page 12