(اضطراری) !!! پروژه Database : رسم دیاگرام ER ، کدنویسی SQL و ارتباط با VB.NET

[amir_arsalan_k2]

بابت انجام این پروژه ، هزینه قابل توجهی پرداخت خواهد شد!

پروژه Database : رسم دیاگرام ER ، کدنویسی SQL و ارتباط با VB.NET

Activities to do

1-List out the possible Business Rules.

2-Identify all the entities and attributes from the given scenario.

3-Draw the E-R Diagram to show the relationship between the entities and attributes.

4-You must use SQL statements to produce your data and load it into MySQL. Take an actual set of data from real life situations. Each Table should not contain more than 20 records.

5-Create a front end GUI using VB.NET only and link it with the MySQL database.

-----------------------------------------------------------------------

Question 1

The TasteGood Restaurant is a Malaysian restaurant serving all types of Malaysian food. It offers a variety of dishes displayed in a set menu. Most of the dishes come in 3 sizes - small, regular and large. However, the restaurant sometimes cooks special dishes at the request of customers at a price fixed by the Chief Waiter.

When a customer comes into the restaurant, he/she will be seated at numbered table and a particular waiter will be assigned to attend to the customer. The waiter will be responsible for all of the customer's requests, from taking the order to serving the food and drinks to collecting the payment.

You are required to design a database to capture the transactions of the restaurant. Customer orders are entered into the system and when payment is received, the receipt can be printed with all the details including the table number, waiter number and payment method (cash/credit card).

Required queries:

List of dishes and drinks offered by the restaurant

List transactions (including the total) for particular days, weeks or month

List of waiters and the number of tables attended by each waiter for particular days

List of top 5 dishes for each day

List of tables and the number of customers seated at each table for a particular day

---------------------------------------------------------------------------

Question 2

Easy Learning is a training centre that provides short courses to corporate customers. The centre plans a series of short courses and advertises the courses through newspapers and mailing lists. The advertisements provide the scheduled dates of the courses, but occasionally the centre would change the training dates due to lack of participants.

Interested customers would call the centre to book a course, and they can book for many participants at the same time to get group discounts. When the number of participants is sufficient, the centre calls the customers to confirm their registration. The course would be conducted when there are at least 10 confirmations. The centre then allocates the classroom and assigns an instructor to conduct the course.

At the beginning of each course, the participants would register at the centre and pay the fees. No refunds would be given in the event that the participant cannot complete the course. During the training, the attendance of each participant would be taken. Only participants with more than 50% attendance are considered to have completed the course and be given a certificate of attendance at the end of the course. The centre would keep track of each participant's information for future references.

Required queries:

List of courses offered and conducted

List of bookings for each course

List of participants for each course

Details of each course - dates, instructor, venue, no. of participants, total fees

List of participants who did not complete each course

----------------------------------------------------------------

What I need to have for BOTH:

Part 1:

A written and softcopy report on the Database portion:

Business Rules

Data Dictionary (A table contains all the entities, attributes, and domains)

Entity-Relationship Diagram

DDL and DML scripts

Queries and reports

Part 2:

A written report and VB.NET program on the development portion:

Fully functioning program with GUIs.

Use case and sequence diagrams.

Simple user manual

[miladamirzadeh]

جالبه! چقدر زمان داری؟

[amir_arsalan_k2]

سلام میلاد جان

واقعیتش زمانم خیلی خیلی کمه ، باید تا سه شنبه تحویل می دادم، اما می تونم استادش رو برای پنجشنبه صبح هم واسه تحویل راضی کنم.
هزینه اش رو هم هر چی باشه پرداخت می کنم.
ببین چه کمکی می تونی بهم بکنی !!!

در ضمن فقط سوال یک (GoodTaste Restaurant) برام کافی هست.
این هم ایمیل شخصی من هست که می تونیم با هم در ارتباط باشیم:
sepehr.parsaei@gmail.com