بابت انجام این پروژه ، هزینه قابل توجهی پرداخت خواهد شد!
پروژه Database : رسم دیاگرام ER ، کدنویسی SQL و ارتباط با VB.NET
Activities to do1-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 1The 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 restaurantList transactions (including the total) for particular days, weeks or monthList of waiters and the number of tables attended by each waiter for particular daysList of top 5 dishes for each dayList of tables and the number of customers seated at each table for a particular day---------------------------------------------------------------------------Question 2Easy 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 conductedList of bookings for each courseList of participants for each courseDetails of each course - dates, instructor, venue, no. of participants, total feesList 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 RulesData Dictionary (A table contains all the entities, attributes, and domains)Entity-Relationship DiagramDDL and DML scriptsQueries and reportsPart 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
