New version page

SJSU CMPE 226 - Practice Problem (02)

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

This preview shows page 1-2 out of 6 pages.

View Full Document
View Full Document

End of preview. Want to read all 6 pages?

Upload your study docs or become a GradeBuddy member to access this document.

View Full Document
Unformatted text preview:

Existing ResourcesDescription of the program that is wantedUse CasesDatabase DesignCmpE 226 Practice ProblemsPractice Problem (02)Class DiagramsPrepare traditional class diagrams 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 mayadd additional object classes.1. A database is being constructed to keep track of the teams and games of a sports league. A team has a number of players, not all of whom participate in each game. It is desired tokeep track of the players participating in each game for each team, the positions they played in the game, their performance in the game, and the result of the game. The database also keeps track of the performance of each player per season and per his or her entire career. Design a Class Diagram for this application, starting any assumptions you make. Choose your favorite sport (e.g., soccer, baseball, football, basketball).2. Design a Class Diagram for a web-based tool called MyBus for the ACME Transportation Authority (ATA). This tool will help user plan a trip on ATA routes. It will allow user to enter the starting and destination location and will give the complete schedule for the bus route from the given starting point to the destination point. It will also calculate the total fare and time for the trip. MyBus will assume that the AVL (Automated Vehicle Location) system is installed on each bus. AVL system will continuously transmit the current location data to the central server at a refreshing rate of 1 minute. Based on this data, MyBus will allow users to see the bus’s current location andwill be able to calculate the actual arrival time of the bus at a given destination. It will also allow user to see the adverse weather (or road conditions – you may add this feature later on) on these routes. Below is the list of the basic relations that you may use for this assignment. You may delete or add more relations if needed, based on ‘real-world’ specifications. Modularity and maintainability will be the key objectives in designing the database.Main Relations:Routes(street_name, x, y, -1, city_name, rno)City(city_name, x, y)BusStation(stationID, x, y, -1, parking_flag)Fare(distance, fare)Pass(typeOfPass, numOfDays, -1, fare)BusStatus(rno, x, y)TrafficConditions(status_flag, x, y)County(county_name, cities) WeekdaySchedule(street_name, t_start, t_end, rno)WeekendSchedule(street_name, t_start, t_end, rno)Disclaimer: ACME Transport Authority (ATA) is an imaginary Transport corporation andcould be assumed for an agency such as Santa Clara’s Valley Transportation Authority3. Problem Statement: Online “Senior Checks” SystemAbstractOSCS-Online Senior Checks System is an interactive, user-friendly system that will enable the SJSU Administrators to perform Degree audits efficiently. It also helps students to find the necessary course requirements needed for advancement towards their Degree. The system helps both the administrators and the students to identify the course requirements, report the deficiencies and advise students in taking classes to meet the requirements, choosing a major, and determining a graduation date. The system also performs administrative tasks, like updating the bulletin information and archiving the audit results.BackgroundThe San Jose State University (SJSU) regularly performs what it calls “Senior Checks” tomake sure that students that will be graduating in the immediate future have met the necessary requirements for graduation. Those requirements include the requirements of any major(s) or minor(s) as well as the general requirements of the college the student is enrolled in, all according to the undergraduate bulletin the student is following. At the present time, this process is conducted by hand and takes several months to process a single student’s request. Immediately before graduation, a student must complete a second check to finalize their status. SJSU is looking to automate this process to increasethe speed, accuracy and efficiency of the senior checks. Specifically, SJSU would like to see this process available with a web-based interface that would allow University administrators quick and easy access to the program without the need for specific software, as well as giving students access to the program to check their own progress towards graduation. Existing ResourcesIn the recent past, SJSU has developed several automated web-based tools related to this problem. The two most relevant resources are the WAM system and the online schedule of classes. The WAM system provides students secure access to their record of classes. The online schedule of classes provides students with access to a searchable database ofthe classes offered during a given class term. These two resources will most likely be helpful in the implementation of any solution to this problem.Description of the program that is wantedSJSU is looking for the development of a program to perform the following main tasks:1. Match the classes a student has taken against the major, minor, and general requirements.2. Report any deficiencies in the student’s requirements.3. Show a list of classes that would fulfill the deficiencies4. Store the results of the check for possible future reference by administrators.5. Each time the bulletin’s requirements are updated the program needs to be able to function with the new requirements.6. An aiding tool for students in choosing their classes7. Obtain statistical information on students and classesDetailed DescriptionIn order to compare the classes a student has taken with those classes that are required, the program must first retrieve the student’s transcript as well as the requirements for the student’s major, minor, and college. The requirements depend on the bulletin year being followed by the student. A student is allowed to follow any bulletin from the academic years during which they attended SJSU. Additionally, there are several classes that may possibly count for several different requirements, such as a class that is both an IS and ESclass. Once both the student’s transcript and all their requirements are retrieved, deficiencies can easily be determined. Any


View Full Document
Loading Unlocking...
Login

Join to view Practice Problem (02) 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 (02) 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?