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 Plus
12 freelance font une offre moyenne de $29 pour ce travail
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 Plus
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 Plus
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 Plus
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 Plus
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 Plus