DOC PREVIEW
SJSU CMPE 226 - Project 1

This preview shows page 1 out of 2 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 2 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 2 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

Database SystemsCmpE 226 Project 1 Spring 20031. Design an MLP /PReSTO constraint database with at least 6 constraint tables. Theconstraint tables should use the full power of linear constraints. (For example, theequality constraint x =1 does not use the full power of linear constraints. So don ’t useonly equality constraints in your database.) The tables should contain a reasonablenumber of constraint tuples, not too few and not too many. Below are somesuggested project topics to help you start thinking about your own project. Each teammust select a unique project and write a description of one page to two pages thatcontain the problem description, brief description of the entities, and their attributes.Submit your project description electronically for approval in one week – Due date isMarch 11, 2003. Submission format is TeamName-ps1.doc. If your team name isAlpha then your project description file is Alpha-ps1.doc.(a) Temperature and blood pressure recordings of patients in a hospital. Approximatethe temperature and blood pressure curves as piecewise linear functions of time.(b) The DOW and NASDA stock indices and other key market indices for severaldecades. Approximate the indices as piecewise linear functions of time. (That is,we don’t need 3650 pieces of data for each index. Use at most 100 pieces in apiecewise linear function to approximate them.) Use database queries to try tofind some interesting relationships among the indices. For example, one indexmay tend to follow the average of some other indices with a certain time delay.)(c) A campus map. Include the area of the buildings. Also show how the buildingschanged over time, i.e., when they were built or expanded in space.(d) A parking lot. Show the parking lot and how cars are entering and leaving theparking lot.(e) A passenger airplane flight scheduler. Include reservations, capacity check for theairplanes.(f) A freight train scheduler. Include stops of the train in cities and amount of carrieditems loaded on and o .at each stop. Include needed amount of items (use severaldifferent items) at each city. Find a shipment schedule that meets all needs.(g) Find a product category that you are interested in (besides crops). Express a linearprogramming problem based on the basic resources that each product needs andthe total amount of resources available. Beside the basic linear programmingproblem include specific details and complications. For example, 1000 units ofresources are available but not more than 500 must be used for product type A.Find other restrictions and variations of the basic linear programming problem.2. Create an ERD (or a UML -- class diagram) for your project. Have at least five 1:1 and 1:M relationships. M:M relationships are not allowed. Try at least one parallel relationship type. Try fully and partly optional, inclusive, and exclusive relationshipsand conditions wherever applicable. Name at least 2 to 5+ attributes per entity. Asyou prepare the diagrams, you may add additional entities. (Note for more flexible requirements: consider any statement starts with Try – optional requirements.)3. Find at least 3 iconic queries or sequence of iconic queries. Explain what they meanand write them down in the style of the examples in the MLPQ system manual.(Iconic queries are shown in Figure 1 MLPQ Graphical Interface in the MLPQSpecifications, such as Intersection, Union, Difference, Max, Min, etc.)4. Find at least 3 SQL queries of each of the following kind: Basic, Aggregation, Sets,and Nested. (That is, a total of 12 queries.)5. Run your queries on the MLPQ/PReSTO system. Save the output relations.6. Turn in the database and the queries in hard copy as well as using the hand inprogram.7. Be prepared to demonstrate your work if asked by the TA or the instructor.Note: You can download the executable file mlpq_nt.exe and some sample .txt files forthe MLPQ/PReSTO system from: http://www.engr.sjsu.edu/~fayad by clicking on the“MLPQ/PReSTO system ”


View Full Document

SJSU CMPE 226 - Project 1

Documents in this Course
SQL-99

SQL-99

71 pages

XML

XML

52 pages

XML

XML

14 pages

Chapter 9

Chapter 9

45 pages

Load more
Download Project 1
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Project 1 and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Project 1 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?