Ultimate Ltd. – Solution for an efficient future

1. Ultimate Ltd. – Solution for an efficient future Neon. “Our creation enlightens your business” Team members: Bianca Milatinovici, Lucian Aparaschivei, Alexandru Litu Project manager: Emanuela Cerchez

2. Business Description • Ultimate Ltd. is a young company that’s been growing continuously since it’s creation in September 2003. It started as a shop in Iulius Mall Shopping Center called “Ultimate Design”. They sold clothes and footwear for teenagers and dynamic young people. • Nowadays the business has different proportions: it runs efficiently 2 stores delivering quality products: clothes, footwear and accessories as well as a brand new fashion line for women, produced in their own mini-factory.

3. References • Interview with ms. Veronica Litu, commercial director of Ultimate Ltd. E-mail: ultimatedsgn@yahoo.com Tel: +40.788.415.381 Address: Bd. Dacia no. 23, Iasi, Romania • Websites referring to similar business: http://www.jigsaw-online.com/ http://www.bluefly.com/ http://www.usoutdoor.com/store/

4. Business Needs • We are interested in creating an efficient database solution for Ultimate Ltd. – a kind of solution that could solve problems, save time and therefore money and answer managerial problems quickly and correct. • Our product has to give automated answers for queries like: “How many products of type X have been sold in the Y period of time?” “What color was best sold in the X store in the Y period of time?”

5. Information Requirements • Ultimate Ltd. needs up-to-date employee information including name, telephone number, birth date, salary, shifts assignments, and the job he/she performs. We uniquely identify employees by their CNP (the correspondent for SSN in USA), or by a shorter artificial id. We classify employees in shop assistants, managers and “other”. The shop assistant that sell the product is listed on the bill. Managers supervise employees and also administrate one or more warehouses.

6. Information Requirements • For each product we keep track of the producer price, store price, description by different properties, and its location history. It is also assigned an artificial code. • For each producer we have an artificial id, an address, a telephone number and an optional profile. Ultimate Ltd. is also interested to know for each producer the contact persons.

7. Information Requirements • For a store we track information such as: address, telephone number, profile (optional), employees, and bills released. A store is uniquely identified by an artificial id. • For each bill we have a unique generated number, payment type, date. It is very important to know the shop assistant which signed the bill and also the store which released it.

8. Business Rules • An employee can work for more than one store. • Each product is unique. Although we have types of product, each one is different from another by propriety (i.e. size, color, material… or just by the ID). • At a time the location for a product can be at the producer, or at the store, or at the warehouse or it can miss, in this case the product is declared sold.

9. Business Rules • Only shop assistants appear the bills. • Every value for a property of a product is stored separately. • When a product appears on a bill it is declared sold. • Each warehouse has a manager responsible for it. • When a product is bought it has no other price than the producer price.

10. Programmatic Rules • The current location of one product is determined from its location history most recent instance. • On a change of price, the end date of the old price is the start date for the new price. • Any changes to time attributes for a shift are made only if the shift isn’t running.

11. Programmatic Rules • When a product is sold, its location history is deleted from the database. • Instances of products are deleted from the database when a determined period of time has passed since it was sold.

12. Assumptions and Constraints Assumptions: • One bill must contain at least one product Constraints: • The attribute end date must state a time later than start date. • We don’t allow a shift to be reassigned to another employee unless the shift had not yet started.

13. have SALARY PROPERTY EMPLOYEE PRODUCT TYPE # date * value for SHIFT #number o description have DAY # CNP (#1) uid * first name * last name * telephone number * birth date # code o description # name #date o description describes appear the time for the classification for contained in for released on the container for OTHER SHIFT ASSIGNMENT for classified by BILL work on # date PRODUCT PROPERTY VALUE contain # bill no * payment type SHOP ASSIST contain listed on PRODUCT have listed supervise MANAGER # code * producer price held by * value releasedby supervised by in charge of appear on PRICE the manufacturer of PRODUCER for # id * address * telephone number o profile # start date * price JOB HISTORY # start date o end date have made by assigned to appear on for have listed on appear on release location for STORE represents LOCATION HISTORY # id * address * telephone number o profile contain CONTACT PERSON # start date o end date # id * first name * last name * telephone number o e mail supervised by contain listed on E R D WAREHOUSE contain # number * address * telephone number listed on

14. Mapping the ERD

15. Mapping the ERD

16. Explanations • Producer price is the price that the product was bought by the store and it won’t be modified. • Attributes description is a text with additional information. • Attributes profile describes activity domain (kids clothing, footwear, men’s clothing …)

17. Conclusions • Our product delivers efficient solutions to managerial problems, saving time and money and raising profitability for our client’s business. • We are certain that our model is creating a solid and stable platform by keeping the structure very well organized and using simplicity as a weapon designed to combat delays and by transforming our product in a trustable tool for the managerial staff.

18. We thank you for your attention. We urge you to trust us!