1. Logical database schema, with the following annotations
   1. Default value, range control, null value control, referential integrity
   2. Example:

Staff (staff No, lastName,branchNo)

primary key staff No NOT NULL (obviously UNIQUE)

foreign key branchNo, references Branch(branchNo) branchNo NOT NULL

Branch (branchNo, address, manager Id, state)

primary key branchNo NOT NULL

foreign key manager Id references Staff(staff No) state DEFAULT "NSW"

CONSTRAINT (0 < managerID < 50 AND state=QLD)