amir_arsalan_k2
یک شنبه 26 شهریور 1391, 11:43 صبح
بابت انجام این پروژه ، هزینه قابل توجهی پرداخت خواهد شد!
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
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