• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Start selling Create your account
Document preview thumbnail
Preview 1 out of 2 pages
Essay

P2- Design a relational database for a specified user need Functional Specification

Document preview thumbnail
Preview 1 out of 2 pages

For P2, learners must design a relational database containing at least five tables for a specified user need. Learners must provide evidence of appropriate normalisation and database design. Documentation such as ERDs, data dictionaries, DFDs, structured English etc will provide the evidence.

Content preview

Pratik Guela
P2-Functional Specification

P2 – Functional Specification
Introduction
I have been asked to design a database system so that students starting a new year
such as 150001 will be assigned a new progress coach. The students also need a
unique ID Number so that they can easily login to the college system and enter there
exams. The client wants me to produce a unique database system that progress
coaches and teachers can view issues/ troubles with students and will be notified.
Furthermore teachers also need to be able to add new issues for students easily.
Lastly progress coaches need to be able to view who is in there groups and 1-1
sessions and view student issues by selecting there student ID.



Client Needs:
 Be able to add new students to the database
 Generate a sequential 10 Number for students that starts with the year they
started (15) then 4 digits starting with 0001 (e.g. 150001)
 Teachers need to be able to add new issues for students when they arise.
 Progress Coaches need to be able to view their groups
 Progress Coaches Need to be able to select a student and view their issues.
 Progress Coaches need to be able to view who are in the 1-1 sessions.




Input, Processes, Outputs

Document information

Study Level
Uploaded on
August 18, 2016
Number of pages
2
Written in
2015/2016
Type
Essay
Professor(s)
Unknown
Grade
Pass
£3.49

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
topqualityworka
3.7
(425)
Sold
2320
Followers
1115
Items
210
Last sold
2 year ago

Reviews from verified buyers




Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their exams and reviewed by others who've used these revision notes.

Didn't get what you expected? Choose another document

No problem! You can straightaway pick a different document that better suits what you're after.

Pay as you like, start learning straight away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and smashed it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions