2_Forms_presentation_l1_v2

Forms in databases

Questions

What is forms?
Where do we use forms?
How does forms ease our life?

Forms

In a database context, a form is a window or screen that contains numerous fields, or spaces to enter data. Each field holds a field label so that any user who views the form gets an idea of its contents. A form is more user friendly than generating queries to create tables and insert data into fields.

Forms

Creating forms ease working process with our database. User can easily input data in text boxes (free fields), without having obstacles with understanding database structure.

Example of form:

Task

Create a prototype of your future database form on a paper. Name all datatypes, length, PK, etc.
Suggested form topics:
Adding new student to a school student list
Adding new football player to a football team
Adding new employee in worker list

Assess each other in pairs!

Thanks for the attention!