Workshop

Quiz

1.	What are the three stages of the design process in software development?
2.	True or False: The design process for software development is usually an iterative process.
3.	What is a use case, and how does it help in the design process?
4.	Imagine that you have two tablesEmployees and Departmentswith the primary key columns EmployeeID and DepartmentID, respectively. If you wanted to establish a one-to-many relationship between Departments and Employees, what would you do?
5.	How does a foreign key constraint guarantee referential integrity?

Answers

1.	The three stages of the design process in software development are as follows: collect design requirements from the customer; for applications that need to persist data, implement the database schema necessary to capture the data spelled out in the design requirements; and create mockups of the web application.
2.	True.
3.	A use case is a paragraph or two describing, in plain English, how a particular task would be accomplished. Use cases help describe a system's functionality in everyday language and can be used to help with creating the database structure and ensuring that the user interface is usable.
4.	To establish this relationship, you would add a DepartmentID column to the Employees table and then create a foreign key constraint, with the primary key column being the DepartmentID field in the Departments table and the foreign key column being the DepartmentID in the Employees table.
5.	A foreign key constraint consists of a primary key column and a foreign key column. It ensures referential integrity by guaranteeing that the value in the foreign key column is either Null or maps to a value in the primary key column. With a foreign key constraint, an error will be raised and the modification will fail if the foreign key column value is changed to a value not in the set of values in the primary key column, or if a primary key column value is changed or the row is deleted and there are corresponding values in the foreign key column.

Exercises

There are no additional exercises for this hour or the remaining two. The creation of the photo album is our main exercise!