Iog, Mjk,.,.,...

Topics: Relational model, Database theory, Database Pages: 6 (1267 words) Published: May 31, 2013
| School of Computing & Media Edexcel BTEC Level 3 Extended Diploma Information Technology| |
STUDENT NAME:| | Campus: Bangor/Downpatrick/Lisburn|
|
Class:| | Issue Date:| w/b 01/10/12|
|
| | Submission Date:| w/b 22/10/12|
|
| | Submission Format| Electronic / Written / Practical / Presentation| |
| | Late Submission| |
|
| | Resubmission Date:| |
|
Unit No:| 18 (J/601/6617)| Assignment No:| 1|
|
Unit Title:| Database Design|
|
Outcome(s):-| 1 Understand the features of relational databases2 Be able to design, create and populate a relational database3 Be able to test a relational database.| Assessment Grade and Criteria| Achieved Y/N| Resubmission Achieved Y/N| Resubmission Achieved Y/N| P2| Design a relational database for a specified user need| | | | P3| Create and populate a database| | | |

P4| Create features in data entry forms to ensure validity and integrity of data| | | | P6| Include an advanced feature in a database design| | | | M2| Import data from an external source| | | |

Student DeclarationI declare that this assignment is all my own work. All sources of information and material I have used within this assignment, including Internet research, have been fully identified and have been referenced accurately. I acknowledge that any work that is found to be plagiarised may result in disciplinary action.| |

Student Signature| _____________________| Date:| |
| | | |
Lecturer Signature| _____________________| Date:| |
| | | |
Cross marking| ---------------------------------| Date:| | | | | |
IV:| ----------------------------------| Date:| |
| | | |

*Attach this page(s) to the front of your completed work*

Assessment Grade and Criteria| Feedback (record and date each feedback occurrence)| | Date| Comments and Action|
P2| Design a relational database for a specified user need | | | P3| Create and populate a database| | |
P4| Create features in data entry forms to ensure validity and integrity of data| | | P6| Include an advanced feature in a database design| | | M2| Import data from an external source| | |

Scenario
You work in a junior role for SERC Computer Consultants as an analyst/designer. You have been asked to support a local company in the development of a new information system to support their business. (Case Study attached) The system specification for your client’s new system has been produced and you are now required to undertake the development/implementation stage of the systems lifecycle for the client’s system.

Tasks:
Task 1 Design a Relational Database (P2)

* Provide the design documentation for a relational database to meet your client’s requirements (see guidance information notes).

Task 2 Implement your Database Design (P3)

* Implement your relational database design and populate the tables.

* Relationships should be established and referential integrity enforced.

Task 3 Data Entry Forms (P4)

* -------------------------------------------------
Use your input specifications to design suitable data entry forms. -------------------------------------------------

* -------------------------------------------------
Use three types of validation to ensure data integrity.

Task 4 Include at least one advanced feature (P6)

* Include at least one of the advanced features from the unit content in your database design (see guidance information for examples). -------------------------------------------------

-------------------------------------------------
Task 5 Import data (M2)
-------------------------------------------------

* -------------------------------------------------
Your client has provided a spread sheet containing typical data. To save time on data entry, import this information into your database....
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • NEBOSH IOG Essay
  • junctionless nanowire transistor Essay

Become a StudyMode Member

Sign Up - It's Free