1 / 19

Database Design Concepts IMAT1408

Database Design Concepts IMAT1408. Lecture 1 Introduction to the module. 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.

aileen
Download Presentation

Database Design Concepts IMAT1408

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Design ConceptsIMAT1408 Lecture 1 Introduction to the module

  2. 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. IMAT1408Database Design Concepts

  3. Database theory (covered in lectures only) Data modelling SQL Report and Form design Database implementation Testing. Module content

  4. Paul Wilson GH6.60 pdcwilson@dmu.ac.uk Module Leader

  5. See separate plan Check your timetable - each week you should have One lecture One tutorial One lab. Teaching schedule

  6. Class session to learn and practise the skills needed for assessments Complete the work in your own study time. Tutorials

  7. 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. Labs

  8. 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. Access

  9. 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. Access continued

  10. 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. Assessment

  11. 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). Assessment continued

  12. Assignment on ER modelling given out in week 3, due in week 6 Worth 20% of the coursework marks. SQL Lab exercise portfolio due in week 9 SQL vivasin week 10 Worth 20% of the coursework marks Assessment scheduleTerm 1

  13. Assignment on Database Implementation - started in lab sessions in week 24 Worth 60% of the coursework marks. Assessment schedule Term 2

  14. 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. Resources

  15. 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. Virtual Learning Environment (VLE)

  16. These will include reading and completing tasks started during classes Expect to spend several hours a week completing these tasks. Tasks for each week

  17. 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. Tasks for this week

  18. 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. Finally

  19. 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.

More Related