DB Topic 9-database design - Databases Topic 9 Database...

Info icon This preview shows pages 1–9. Sign up to view the full content.

© NCC Education Limited V1.0 Databases Topic 9: Database Design
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Database Design Topic 9 - 9.2 © NCC Education Limited V1.0 Scope and Coverage This topic will cover: Understanding requirements Moving from entities to tables Documenting attributes with a data dictionary The use of Case tools
Image of page 2
Database Design Topic 9 - 9.3 © NCC Education Limited V1.0 Learning Outcomes By the end of this topic, students will be able to: Understand the process of requirements gathering Design a set of database tables from an entity model Document the tables, columns and domains in a database using a data dictionary Understand the use of Case tools
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Database Design Topic 9 - 9.4 © NCC Education Limited V1.0 Systems Analysis The art of understanding and documenting the requirements of a given set of users within the context of an organisation.
Image of page 4
Database Design Topic 9 - 9.5 © NCC Education Limited V1.0 Systems Development The development of the whole system from beginning to end . This might include a database, applications, a network etc.
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Database Design Topic 9 - 9.6 © NCC Education Limited V1.0 Approaches 1. Traditional systems development lifecycle (SDLC) or ‘ waterfall’ approach 2. Iterative approaches
Image of page 6
Database Design Topic 9 - 9.7 © NCC Education Limited V1.0 Strategy and Planning Feasibility Study Systems Analysis The Waterfall Lifecycle
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Database Design Topic 9 - 9.8 © NCC Education Limited V1.0 Generic Systems Development Lifecycle - 1 1. Strategy and planning 2. Feasibility study 3. Systems analysis (or analysis) 4. Design 5. Implementation 6. Maintenance
Image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.
  • Summer '16
  • Databases, Entity-relationship model, Relational model, NCC Education Limited, Database Design Topic

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern