Answer the following quiz questions.
- During what phases of the software development life-cycle do we first create the following: UML use-case diagrams; user stories; and UML class diagrams?
- Would Brooks categorize the problems caused by an inappropriate programming language as essential or accidental difficulties?
- Is a login (screen) an appropriate class to include in a domain model?
- What are the elements of Nielsen’s discount usability process?
- Name the N. Postman idea for this unit, and explain why it does or doesn’t matter.
Compare and contrast the following pairs of terms.
- Database Management System (DBMS) vs Information System
- Database vs. DBMS
- Semantic vs. Logical data models
- External, Conceptual/Logical vs. Internal schemata
- Relational key vs. traditional pointer
Consider a construction domain in which suppliers supply parts to job sites. Suppliers have a name, address, loginID, and password. Parts have a SKU number, name, price. Jobs have a name, address.
- Build a relational model for the suppliers (only). Include the age of the relationship with this supplier.
- Add parts. Note that while parts are generic, e.g., a “widget” could be supplied by many suppliers, a business decision has been made to buy each part from exactly one supplier.
- Add jobs where a part can be used on many jobs and a job can use many parts. Include the quantity of parts supplied to each job and the date of each transaction.
Create a sample database with records that specify the following.
- Companies: Acme; Ronco
- Products: Birdseed; TNT
- Jobs: Student Union; an unnamed job (both at Calvin)
- Deliveries (product→job):
- 10 boxes of birdseed to the Student Union job on Oct 20
- 2 units of TNT to the unnamed job on Oct 21
- 3 boxes of birdseed to the unnamed job on Oct 21
Modify the database schema from the previous exercise to do the following.
- Allow parts to be made up of other parts. Include the ability to represent the quantity of each sub-part required for a super-part.
- Allow each job site to choose the supplier of its parts rather than having the company enforce a standard across all sites.
Give some sample records that demonstrate how the structure works.
Specify a database schema that represents people and their biological and legal relationships. This includes families, parentage, siblings, etc. Each person has a name, gender, age.
For the strong of heart, try to support adoption, divorce, remarriage and group marriage.
What was Postman’s third idea and do you agree with it?