You need to track the following: For the supply product, your design must be able to store: • the supply’s classification (i.e. Paper Clip, Staples, Toner, etc.) • the supply’s retail name (i.e. Happy Time Paper Clips Cannon G-123 Toner, etc.) • the supply’s retail cost (price in dollars). • the supply’s packaging size (Small, Medium or Large) • the supply’s ordering quantity (whole number, i.e. 1, 2, 3 …) For the vendor, your design must be able to store: • the vendor’s Company Name. • the vendor’s product type (i.e. stationery, consumable (coffee, soda), electric, multiple, etc.) • the vendor’s location (relative to your company) (either local or out of town) (only two options !) • the vendor’s working date (date of first order ever with this vendor) You are to add (create, make-up) two more attributes for the vendor. (For example, the vendor’s address or phone number (obviously you cannot use either of these as I just gave them to you.) For the employee, your design must be able to store: • the employee’s Last Name and First Name. • the employee’s complete address: • street • city • province • postal code – the employee’s address (street, city, province and postal code) data can be blank. – i.e. the employee’s listing can exist even of these fields are left unfilled. • the employee’s phone number • the employee’s employment date (i.e. date employee was hired on.) All attributes are to be considered as mandatory unless specifically stated above. All attributes are to be considered as non-unique unless the design specifically requires them to not contain duplicate entries. HINT: fields are missing in each of the above. Hopefully, it will be very obvious …. Next, you need to store the following relationships: A vendor makes a product, An employee will oversee a product. An employee will work (liaison) with a vendor. • A vendor may make one or more products. • A vendor can still be listed even if they do not make any product we use. • A product must be made by at least one of the vendors. • A product can be made by more than one vendor. • An employee may liaison with one and only one vendor. • Not all employees will be assigned to liaison with a vendor. • A vendor must be assigned to one and only one employee with which to liaison. • A product must be managed (overseen) by one and only one employee. • An employee might (or might not) manage (oversee) one or more products.
ADDITIONAL HINT: your diagram will contain four (4) entities