Question: 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
 This is the actual database system. Your system must have at

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!