Transcript Week1 Introduction to module(4)x

Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
C
o
n
c
e
p
t
s
Database Design Concepts
IMAT1408
Lecture 1
Introduction to the module
HNDComputing – DeMontfort University
DeMontfort University 2011
wk1
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
C
o
n
c
e
p
t
s
wk1
IMAT1408
Database Design Concepts
• This is one of four modules you will do this year
(three if you are studying part-time)
• Covers the HND requirements for Databases
If you put effort into this module you will find
projects much easier next year.
HNDComputing – DeMontfort University
DeMontfort University 2011
2
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
C
o
n
c
e
p
t
s
wk1
Module content
•
•
•
•
•
•
Database theory (covered in lectures only)
Data modelling
SQL
Report and Form design
Database implementation
Testing.
HNDComputing – DeMontfort University
DeMontfort University 2011
3
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
C
o
n
c
e
p
t
s
wk1
Module Leader
• Paul Wilson
GH6.62
[email protected]
HNDComputing – DeMontfort University
DeMontfort University 2011
4
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
wk1
Teaching schedule
• See separate plan
• Check your timetable - each week you should have
– One lecture
– One tutorial
– One lab.
C
o
n
c
e
p
t
s
HNDComputing – DeMontfort University
DeMontfort University 2011
5
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
wk1
Tutorials
• Class session to learn and practise the skills needed
for assessments
• Complete the work in your own study time.
C
o
n
c
e
p
t
s
HNDComputing – DeMontfort University
DeMontfort University 2011
6
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
wk1
Labs
• Practical exercises and portfolio work
• Complete the work in your own study time
• Time spent practising this year will pay off when
you do your project next year.
C
o
n
c
e
p
t
s
HNDComputing – DeMontfort University
DeMontfort University 2011
7
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
C
o
n
c
e
p
t
s
wk1
Access
• We will use Microsoft Access 2007 in the Labs
• Many of you have used Access before – we will
probably use it differently
• We will be using Visual Basic for Applications
(VBA) together with MS-Access
• If you have not used Access tell me.
HNDComputing – DeMontfort University
DeMontfort University 2011
8
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
C
o
n
c
e
p
t
s
wk1
Access continued
• You will need to work on Access after lessons:
– It is available on nearly all University PCs
– You may have Access on your own PC
– We are currently using Access 2007. Working at
home is fine as long as the version of ACCESS
you have installed is compatible.
HNDComputing – DeMontfort University
DeMontfort University 2011
9
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
C
o
n
c
e
p
t
s
wk1
Assessment
• 70% of the module marks come from coursework
• Assignments and vivas with your tutor throughout the
year – you must submit work on time and be present
for the vivas.
• Database Development Project in the second term
• Module schedule gives dates when assignments are
handed out and when they are due in
• There are severe penalties for late work and copying.
HNDComputing – DeMontfort University
DeMontfort University 2011
10
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
C
o
n
c
e
p
t
s
wk1
Assessment continued
• 30% of the module marks come from the exam (in
May)
• You need 40% on the module to pass
• You must pass to get into the 2nd year
• It is easiest to pass if you come to all your classes
and complete the work (yourself).
HNDComputing – DeMontfort University
DeMontfort University 2011
11
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
C
o
n
c
e
p
t
s
wk1
Assessment schedule
Term 1
• Building a Database laboratory workbook demo
and viva, due in week 7
Worth 20% of the coursework marks.
• E-R modelling Assignment distributed in week 6
due in week 11
Worth 20% of the coursework marks
HNDComputing – DeMontfort University
DeMontfort University 2011
12
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
wk1
Assessment schedule
Term 2
• Assignment on Database Implementation - started
in lab sessions in week 24
Worth 60% of the coursework marks.
C
o
n
c
e
p
t
s
HNDComputing – DeMontfort University
DeMontfort University 2011
13
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
C
o
n
c
e
p
t
s
wk1
Resources
• Lecture notes will be provided for each lecture
on Blackboard
• References are given at the end of lectures for
additional information. Find the books in the
library, you do not have to buy them
• Tutorial and lab exercises will be supplied as
handouts or workbooks.
HNDComputing – DeMontfort University
DeMontfort University 2011
14
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
C
o
n
c
e
p
t
s
wk1
Virtual Learning Environment (VLE)
• This module is supported on the University VLE, which
is called Blackboard
• Everyone is registered on Blackboard when they enrol at
DMU. If you have problems, contact the Student Advice
Centre
• Check Blackboard regularly for messages and additional
materials
• Course materials will be added to Blackboard
• Reading the notes on Blackboard is not a substitute for
attending classes.
HNDComputing – DeMontfort University
DeMontfort University 2011
15
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
wk1
Tasks for each week
• These will include reading and completing tasks
started during classes
• Expect to spend several hours a week completing
these tasks.
C
o
n
c
e
p
t
s
HNDComputing – DeMontfort University
DeMontfort University 2011
16
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
C
o
n
c
e
p
t
s
wk1
Tasks for this week
• Identify your tutorials and labs
• Go to the library and find the database books
• Get your password and user id before your lab
session
• If you have not used Access before tell your
tutor in your first lab session
• After your lab, finish setting up the Phones
database.
HNDComputing – DeMontfort University
DeMontfort University 2011
17
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
C
o
n
c
e
p
t
s
wk1
Finally
• You have to pass this module before you can go into year
2
• You get one attempt at each assessment during the year
• If you do not attend a viva or do not hand in an
assignment without good reason you get 0% for it
• The module Resit is in August by exam only (no
coursework)
• It is easiest to complete the module first time through by
attending lessons and doing the work on time.
HNDComputing – DeMontfort University
DeMontfort University 2011
18
Introduction to Module IMAT1408
D
a
t
a
b
a
s
e
D
e
s
i
g
n
C
o
n
c
e
p
t
s
wk1
NEXT LECTURE – Getting started on
understanding Database technology - how they
work and how database applications can be
designed to organise vast amount of data, thus
enabling I.T. systems to deliver useful
functionality to the computer user.
HNDComputing – DeMontfort University
DeMontfort University 2011