Understanding CRUD Requirements

• ·         One who gives expert or professional advice - consultant
• ·         The practice of checking a data model for create, retrieve, update and delete functions that the business requires – CRUD analysis
• ·         Used to perform calculations on data, modify individual data items, manipulate output for groups of rows, format dates and numbers for display, convert column datatypes. - functions
• ·         No longer in use - obsolete

1. Identify the part of the CRUD analysis that best suits the task in the table.

• Create

• Retrieve

• Update

• Delete

Alter	Update
Bring up	Retrieve
Change	Update
Discard	Delete
Enter	Create
Find	Retrieve
Import	Create
Input	Create
Load	Create
Look up	Retrieve
Modify	Update
Print	Retrieve
Purge	Delete
Read	Retrieve
Record	Create
Remove	Delete
Report	Retrieve
Trash	Delete
View	Retrieve

2. Relate CRUD analysis to a school enrollment environment. Consider the data or information used in a school and identify at least one example for each CRUD function.

a. Create:

Student enrolls in a subject, and enrollment details are saved in DB.

b. Retrieve:

Student logs in blackboard on first day of session, and he can see all the courses he enrolled to on home page.

c. Update:

Student goes to myPortal and gives a new mobile number since he took a new mobile with new number.

d. Delete:

Student no longer wants his parents to see his scores are report card. So, he goes to myPortal and removes the authorization.