View the step-by-step solution to:

You have the following tasks: A conceptual model of databases that will be used for your Project 1.

hi profeesor,

i need help with the project

One of your first tasks is to develop a database.  You have the following tasks:

A conceptual model of databases that will be used for your Project 1.You should list 3 major database tables to be used by the company, their contents (e.g., list of fields) and interrelationships (ER diagram). List 3 database queries that the company will use most commonly with these databases.

Deliverable: Can be a word document, PPT or a zip file( if you have multiples files to upload)   you did my project 1 chroma restaruant

Sign up to view the entire interaction

Top Answer

Here is the explanation for... View the full answer

choma.docx

Queries
1. List customers and orders made
SELECT `CustFirstName`,orders.OrdNo,orders.OrdNo FROM `customer`join orders on
orders.CustNo=customer.CustNo 2. List all customers from WA
SELECT * FROM...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online