Identify the business rules. Remember, these are always bi-directional.
2. From the business rules identify the entities and their relationships.
3. Draw the ERD in MySQL Workbench.
4. Prove that each table is in third normal form.
5. Insert at least 3 rows of data for each entity.
6. Write the SQL that will answer the following questions
Are there any tours for which there are no qualified guides?
Are there any guides that are not qualified to lead any tours?
Are there any outings that have no clients booked?
I worked on similar projects previously in freelancer.com. Experienced in creating crows-leg ER diagrams using Visio and creating database using forward engineering. Relevant Skills and Experience I have vast experien Daha Fazla
12 freelancers are bidding on average $29 for this job
Hi, I went through the requirements. I can do this one if given the opportunity. Let me know if you are interested. Thanks. Relevant Skills and Experience MySQL, Database Development Proposed Milestones $30 USD - Pro Daha Fazla
Dear Client Can we do quick chat right now so that we can discuss the project briefly? Relevant Skills and Experience I am full time freelancer.I have strong communication skills and have flexible working hours. I as Daha Fazla
Hi hope you are doing well. I have taken a look at your task and I have confidence that we can work together, I have lot of experience in this field, so give us a chance to work with you. Relevant Skills and Experienc Daha Fazla
i am web developer and have rich experience in database processing i can do your task thanks Relevant Skills and Experience mysql Proposed Milestones $25 USD - all when you give me task , i will start right soon
Hello, I read all your requirements and I can provide it in given time and in less budget. I am a PHP developer, I have expert level knowledge of HTML, CSS, BOOTSTRAP, JQUERY, PHP, CI, LARAVEL etc. Relevant Skills and Daha Fazla
This seems as a college data base course assignement. As it's something basic I can assure correctness, quick delivery, good documentation and any help needed to understand the deliverable. Relevant Skills and Daha Fazla
can do this easily I m pro in database. I can show u my sample work s