DOC PREVIEW
SJSU CMPE 226 - Practice Problem (08)

This preview shows page 1-2-3-4 out of 11 pages.

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

Unformatted text preview:

Database DesignAbstract:Domain Description:Usecase:1. Description of Entities and its Attributes:Entity Type 1:Entity Type 2:Entity Type 3:Database DesignDatabase DesignCmpE 226 Practice Problems Practice Problem (08)________________________________________________________________________1. Design a database with at least 10-12 of tables or ((constraint tables. The constraint tables should use the full power of linear constraints. (For example, the equality constraint x =1 does not use the full power of linear constraints. So don ’t use only equality constraints in your database.)) The tables should contain areasonable number of tuples or (constraint tuples), not too few and not too many. 2. Prepare traditional class diagram for the following problems showing at least 10 relationships among the following object classes, including associations, aggregations, and generalizations. Show multiplicities in your diagrams. Your model should have 3-5 attributes and 3-5 operations per class. Use association and role names when needed. As you prepare the diagrams, you may add additional object classes.3. If you use MLPQ, find at least 4 iconic queries or sequence of iconic queries.Explain what they mean and write them down in the style of the examples in theMLPQ system manual. (Iconic queries are shown in Figure 1 MLPQ GraphicalInterface in the MLPQ Specifications, such as Intersection, Union, Difference,Max, Min, etc.)4. Find at least 4 SQL queries of each of the following kind: Basic, Aggregation, Sets,and Nested. (That is, a total of 16 queries.)________________________________________________________________________GPS based Emergency Services SystemAddgroup Abstract:For every country, emergency (EMR) medical system is very critical in saving humanlife. When an emergency erupts, an extra second or two can mean the difference betweena life saved and a life lost. Adding GPS tracking to emergency systems would be avaluable support. GPS is a global positioning system based on satellite technology. AllEMR centers are equipped with centralized GPS emergency system. When emergencycalls are made, the call reaches the nearest EMR center based on the area the call iscoming from. The emergency call is immediately updated in the centralized system. The basic purpose of our GPS based emergency system is to get people rescued as fast aspossible. The system can show the entire area on a digital map allowing emergency callsto be pinpointed instantly. Emergency vehicles are displayed as icons so the nearestavailable unit can be determined.Domain DescriptionDomain Description:The GPS based emergency services system includes a GPS receivingunit that is provided on the emergency vehicle. This unit receives GPSsignals from GPS satellites and determines location information of theemergency vehicle. The system also includes a radio-wave transmitterunit that is provided on the emergency vehicle. This unit transmits theemergency vehicle location information by way of an emergencyvehicle location signal to a radio-wave receiver unit that is provided inthe EMR center. The registered patients are given handsets with GPS-enabled chipsets and transmitters. These handsets are location-awareportable wireless networked devices. When an emergency occurs, hepresses the button on the handset. EMR center will receive the signalthrough the receiver. The system pinpoints the location of both theregistered patient and the nearest emergency vehicle on a computermap. The database will be updated every one minute with the currentlocation of emergency vehiclesMajor services provided by this system are listed as follows:Tracking of nearest emergency vehicles:All EMR vehicles are tracked by GPS system so as to attend any patients in a short period. The centralized system identifies the nearest vehicle for this patient,directs it to patient and then to the hospital. Finding Available Medical service:This system maintains the list of emergency hospitals, physicians, staffs and emergency rooms. This system will help the patient by finding the nearest hospital with available doctors, staffs and emergency rooms. GPS for critical patients: Some patients have more probability to get admitted. For instance, aged people, heart patients etc. They could register their names in GPS system and get the immediate response in case of emergency. They need to only press the button for calling this emergency system. This system even maintains the list of persons to contact so that the information could be passed to them. Then the same procedure would be followed to get nearest emergency vehicle as well as medical service. Medical Inventory Database:This system will direct the emergency vehicles to reach the nearest inventory and to get needed medicines and first aid equipments like first aid kit, oxygen cylinder .Any m emergency medical center make use of this system.Area based services:The whole country is divided into many areas each with a unique area code. This system keeps track of all areas and their recorded requests to GPS based emergency system. Number of vehicles will be increased for the region with high rate of requests. Demographic information could be collected for each area and number of vehicles for each location could be decided based on its population. Disaster Management:The historic data for each area could be collected .For example, some east coastal have hurricane during particular season in every year. It maintains the link to access the corresponding system responsible for each disaster type. More services could be preparedfor those areas in that period. Some seasonal diseases also monitored in each year and number of services could be increased accordingly. Detailed requirements that include use casesUsecase:Usecase 1: If a registered patient suddenly gets a heart attack. Steps: 1. A registered patient presses the button of the GPS enabled hand set given to him.2. The EMR center receives the location of the patient in the form of signal.3. The EMR center tracks the available emergency vehicle nearer to the patient and directs it to the patient.4. It also finds the nearest hospital that has the necessary resources to attend the patient.5. It then directs the emergency vehicle carrying the patient to the hospital.6. It then informs about the patient to their contacts.In this way, the critical patient is saved from heart attack in very short time. Usecase 2:


View Full Document

SJSU CMPE 226 - Practice Problem (08)

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 Practice Problem (08)
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 Practice Problem (08) 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 Practice Problem (08) 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?