Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is the actual database system. Your system must have at least the following items: a . 3 tables that are connected to each other,

This is the actual database system. Your system must have at least the following items:
a.3 tables that are connected to each other, e.g. table 1 connects to table 2, and table 2 connects to tabled 3.(20')
b. Abundant sample data records to simulate a real-world case. For instance, if you build a database for a doctor's office, you should have more patients than doctors (in the DOCTOR table, you can have 5 doctors, and in the PATIENT table, you can have 50 patients).(20')
c.5 different types of queries reflecting routine tasks. "5 different types" means each query will use a different technique, e.g.1 query has a "where" clause, 1 query uses "like", 1 query uses "order by",1 query uses "distinct", 1 query is a "j" operation. If you use different built-in functions, they are considered same type of query, -. g. a query using "sum 0" and a query using "count()" will be considered the same type, however, if a query uses both "sum0" and "where", it will be considered a different type of query from a query using only "count(0" because of the "where" clause. You can have more than 5 queries and a same technique can appear in multiple queries, as long as there are 5 queries where a unique technique can be found in each. (20')
d. Correct relationship definition
E. Show the tables, fields, and realtionship
image text in transcribed

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

Professional SQL Server 2000 Database Design

Authors: Louis Davidson

1st Edition

1861004761, 978-1861004765

More Books

Students also viewed these Databases questions