2010년 11월 14일 일요일

[Beauty Shop Management Programm] 2.Database Modeling

I will use SQL Sever 2005 Express as a database because it goes well with ASP.NET. If you want, you can change database to other products such as MySQL, PostgreSQL, and so on esaily because ASP.NET usually uses ORM framework(LINQ to SQL, Entity framework, NHibernate) to handle database. It make it possible persistent layer dependant to your database, so it doesn't matter which database you are using as your DBMS.
If you don't have SQL Server 2005 or 2008 Express, please go to Micorsoft web site and download one of them. I remember that after installation SQL Sever 2005 Express, it causes a problem because of Windows account. Then, just googling.

The datase will include customer, designer, item category, item, sale, customer-sale, designer-sale information.

[Beauty Shop Management Programm] 1.Create Usecase Diagram

First step of this project is to create Use Case Diagram which show functions you need in this application. My result of Use Case is following:

Actors are customers, designers, and admin. We can extract some function from this business.
[Customer]
A customer makes an appointment with a designer.
A customer orders services.
A customer purchases beauty items.
A customer gets a refund items he bought after payment.
A customer pays for fare.
A customer signs up.
A customer uses having points.
[System]
System prints invoices.
System accumulates points.
System changes points.
[Designer]
A designer view bookings.
A designer offers services.
[Admin]
A administrator logins to the system.
A administrator input member detail.
A administrator input items.
A administrator views reports.
A administrator send mails.

I create the Use Case Diagram for a beauty shop and defined functions. This would not be the best, but it will be enought to proceed Beauty Shop project.