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
✓ Extra quality
ExtraProxies brings the best proxy quality for you with our private and reliable proxies
✓ Extra anonymity
Top level of anonymity and 100% safe proxies – this is what you get with every proxy package
✓ Extra speed
1,ooo mb/s proxy servers speed – we are way better than others – just enjoy our proxies!
USA proxy location
We offer premium quality USA private proxies – the most essential proxies you can ever want from USA
Our proxies have TOP level of anonymity + Elite quality, so you are always safe and secure with your proxies
Use your proxies as much as you want – we have no limits for data transfer and bandwidth, unlimited usage!
Superb fast proxy servers with 1,000 mb/s speed – sit back and enjoy your lightning fast private proxies!
99,9% servers uptime
Alive and working proxies all the time – we are taking care of our servers so you can use them without any problems
No usage restrictions
You have freedom to use your proxies with every software, browser or website you want without restrictions
Perfect for SEO
We are 100% friendly with all SEO tasks as well as internet marketing – feel the power with our proxies
Buy more proxies and get better price – we offer various proxy packages with great deals and discounts
We are working 24/7 to bring the best proxy experience for you – we are glad to help and assist you!