Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Trying to create a database for something like a small restaurant. If possible please attach a picture of an Entity relationship diagram Part A. Database

Trying to create a database for something like a small restaurant. If possible please attach a picture of an Entity relationship diagram image text in transcribed
Part A. Database Creation Design and create a relational database containing information on a collection of items, field of study, hobby, or special interest you may have. Your database should have a minimum of 4 the main tables (entities), and whatever relationship tables are needed. Your tables should have fields with different data types such as numeric and or date fields. Define all appropriate constraints, using the proper naming conventions (see Structure Notes below). Populate your main tables (entities) with at least 10 records cach. Submit the following Short description of the purpose of the database and what the data and relationships mean Entity Relationship Logical Data Model of your database showing the relationships and the cardinality for each DDL used to create your database Part B. Queries Create queries that include the following. You may use more than one of the listed conditions in the same query. I. Retrieve subset of columns. 2. Uses a simple condition. 3. Uses a compound condition. 4. Uses the LIKE, IN, or BETWEEN operators 5. Uses an aggregate function. 6. Uses the GROUP BY clause. 7. Uses joins to retrieve data from more than one table. 8. Use the IN or EXISTS operator. 9. Use a subquery. 10. Performs a join of some kind. For each query, submit the following: Question the query is trying to answer (c.g. similar to the questions in your book like 'What is the price of the most expensive item?") The SOL for the query that answer the question . The query results. STRUCTURE NOTES: Use the proper naming convention for your constraints: Example: Constraint TableName FieldName ConstraintID (Customer CusNum PK) Set up the Primary Keys for each table with Constraints Set up any Foreign Key constraints for cach table with constraints listed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Management Databases And Organizations

Authors: Watson Watson

5th Edition

0471715360, 978-0471715368

More Books

Students also viewed these Databases questions

Question

How wide are Salary Structure Ranges?

Answered: 1 week ago