Other
Data dictionary
- Institution
- PEARSON (PEARSON)
Data dictionary for the database with data normalised and sorted
[Show more]
1 review
By: mohamedismailbda • 6 year ago
Content preview
Course: BTEC National DiplomaUnit : 18 – Database Design
Topic: Data Dictionary / Schema
You are to decide what data Types and Formats the following data items should be, and what validation checks should carried out:
Data Validation rules/input
Entity name Key Attribute/Field Data Type Format/ Rqd masks/lookups/drop down Description
Length/Size lists
Tbl_customer PK Auto Yes Customer unique ID number
Customer ID number
Title Look up Drop down Yes DDL, Mr, Mrs, Miss Customer title e.g Mr
wizard
First Name Short text 25 Yes Is Null OR Not Like "*[!a- Customer first name
z]*"
Surname Short text 25 Yes Is Null OR Not Like "*[!a- Customer last name
z]*"
Address line 1 Short text 45 Yes Is Null OR Not Like "*[!((a- Customer address line 1
z) or (0-9))]*"
Address line 2 Short text 45 No Is Null OR Not Like "*[!((a- Customer address line 2
z) or (0-9))]*"
Town Short text 35 Yes Is Null OR Not Like "*[!a- Customer town
z]*"
County Short text 40 Yes Is Null OR Not Like "*[!a- Customer county
z]*"
Postcode Short text 35 Yes >LL09\ 0LL;;* Customer postcode
Tel No Short text 11 Yes Is Null OR Not Like "*[!0- Customer contact number
9]*"
Short text 30 Yes Is Null OR ((Like "*?@?*.? Customer Email
*") AND
Email (Not Like "*[ ,;]*"))
Member y/n Look up Drop down Yes DDL, Y/N Is customer member or not
Wizard
Surcharge Currency Decimal Yes £ 2DPL Surcharge for customers from
outside
Payment method Look up Drop down Yes DDL, Cash, Direct debit, Credit Customer payment method
wizard card
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller vicky123. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £5.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
51292 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 15 years now