Iog, Mjk,.,.,...

Only available on StudyMode
  • Download(s) : 14
  • Published : May 31, 2013
Open Document
Text Preview
| 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....
tracking img