pleas help.. Overview:National railway company wants to make a simple application to keep track of trips andpassengers.In this TMA, it is required to help the company implement the required application.Requirements:After a quick meeting with the employee in charge, you got the following information:• It is required to store the whole data in one collection•Each trip has a number, a driver and a specific date. In addition, passengers could be addedor removed within a given limit for the maximum number of passengers who could be in thesame trip. Furthermore, there are other attributes (add at least 3 attributes from yourchoice). Of course, trip number is unique within the same date.Each driver has a unique ID, a name and other attributes (add at least 2 attributes from yourchoice).Each passenger has a unique Civil ID (National ID), a name and other attributes (add at least2 attributes from your choice but one of them should be common with drivers).Moreover, you have been informed that the following operations happen frequently:• Offering a new trip•Adding a passenger to a specific tripRemoving a passenger from a specific tripRetrieving the average number of passengers per trip of a specified dateDisplaying all available trips in a format similar to the following:date1: tripNo1 tripNo2 tripNo3...date2: tripNo1 tripNo2 tripNo3...where dates and trips are sorted in ascending order• Saving all the data into a text fileAnalysis:Q1: There are common attributes and methods between passengers and drivers. What is thebest choice for designing and writing the codes of these two classes? Explain your answer.Q2: Draw a simple dass diagram showing only relationships between the classes.Implementation:After analysing the given requirements, implement the required application:• with Object Oriented Programming style• following the rules of good programming style (eg. adding comments, etc.)using only the material covered in M251 (and its prerequisites) Hints:• For each class, it is required to implement constructors, setters, getters, toString() method,and any other necessary method•If the user tries to do an operation that could violate the state of objects, the operationshould be ignored and the application should display an error message (e.g. adding apassenger to the same trip twice, etc.)Checking equality of any 2 objects should be done via the equals() methodThere is a class that will do the main job of as follows:It has one collection to store the whole data (all trips)It has static methods, one for each operation happens frequentlyFor each adding or removing operation, a message should be displayed to the user toexplain the status of the operation (i.e. if it was successful or not)••oooTesting:After implementing the required classes, design and implement a testing class to test them asfollows:• Create at least 7 trips in at least 3 different dates and add them to the collection that storesthe whole data then add and remove some passengers from them.• Try to violate the state of the objects and show that your code prevents all violations.Show that the other operations that happen frequently are working fineAt the end, the whole data should be saved into a text file and this file should be savedautomatically inside the folder contains your Java project

Overview: National railway company wants to make a simple application to keep track of trips and passengers. In this TMA, it is required to help the company implement the required application. Requirements: After a quick meeting with the employee in charge, you got the following information: . It is required to store the whole data in one collection • Each trip has a number, a driver and a specific date. In addition, passengers could be added or removed within a given limit for the maximum number of passengers who could be in the same trip. Furthermore, there are other attributes (add at least 3 attributes from your choice). Of course, trip number is unique within the same date. • Each driver has a unique ID, a name and other attributes (add at least 2 attributes from your choice). • Each passenger has a unique Civil ID (National ID), a name and other attributes (add at least 2 attributes from your choice but one of them should be common with drivers).

Overview: National railway company wants to make a simple application to keep track of trips and passengers. In this TMA, it is required to help the company implement the required application. Requirements: After a quick meeting with the employee in charge, you got the following information: . It is required to store the whole data in one collection • Each trip has a number, a driver and a specific date. In addition, passengers could be added or removed within a given limit for the maximum number of passengers who could be in the same trip. Furthermore, there are other attributes (add at least 3 attributes from your choice). Of course, trip number is unique within the same date. • Each driver has a unique ID, a name and other attributes (add at least 2 attributes from your choice). • Each passenger has a unique Civil ID (National ID), a name and other attributes (add at least 2 attributes from your choice but one of them should be common with drivers).

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Access Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…
EventHelpers is a company that specializes in event medical assistance. They can hande any type of medical emergency. The company has a range of employees from first aiders to paramedics with degrees. EventHelpers has contacted you to help them design the database so that they can keep track of which employees went to which events. The company provided you with the following details: • Afirst aider has a certificate, which indicates the expiration date of the certificate. The certificate has to be renewed every three (3) years. • A paramedic has a degree that does not expire. • The company needs the ID, Name, Sumame, Contact details, and the address of each employee. • The company sends several medical assistants, a few first aiders and, depending on the size of the events, 1-3 ambulances, to each event. • Each medical assistant is paid per hour based on their qualificafion. To book EventHelpers for an event, the following details are required: • The name of the event. • The time and…
Next year, God willing, Arab Open University will organize an international conference. On the sidelines of the conference, many workshops will be held. It is required to help the organizers implement an application to keep track of all workshops and attendees. Requirements: After a quick meeting with the organizers, you got the following information:  Each attendee has a unique passport number, a name and other attributes (add at least 2 attributes from your choice).  The whole data should be stored in one collection such that for each workshop, all attendees associated with it could be retrieved easily and directly.  There is a text file including the names of all available workshops (each workshop is in a separate line) ImplementationAfter analysing the given requirements, implement the required application:  with Object Oriented Programming style  following the rules of good programming style (e.g. adding comments, etc.)  using only the material covered in M251 (and its…
An insurance company needs to store their salespeople’s information who are selling their insurance policies. They already have a database with multiple tables, one of the tables (Salesperson) stores information about each salesperson along with the bonus percent they receive, based on the city where the insurance is sold. The table has the following fields: Salesperson(spID, spName, spBirthDate,spCitySelling, bonusPercent) spID: Unique identification number of the salesperson. spName: Full name of the salesperson. spBirthDate: Birthdate of the salesperson. spCitySelling: The city in which the salesperson is selling the insurance. bonusPercent: The bonus percent received by the salesperson based on the city in which he/she sells the insurance. Each salesperson can sell the insurance in just one city. However, for a city, there can be more than one salesperson appointed. Also, the bonus percent is fixed for each city. For example, all of the salespeople who sells insurance in…
A rail transport company wishes to hold details of train services, stations and operators. Details include the following: Trains: A train has a unique id code, a collection of days it runs on (Monday, Sunday etc.), and the number of carriages it has. Each train must have at least one driver but can have many drivers that can drive it, and a driver may drive many trains. Each driver is identified by an employee number and a name. A train is designated as either an InterCity or District train though other types of train are possible. Each train must have an operator and not more than one operator. Each operator has a name and a phone number. The operator can operate many trains (or none at all!) Stations: A station has a name and the number of platforms it has. All stations are classified as either Main or District only. There are no other types of stations. Timetable: A train has a number of stops at a station during its journey. It never visits the same station twice on the same…
ID At_fault_claims 1001 0 1001 1 1002 0 1002 1 1002 1 1003 0 1004 1 1005 1 1005 0 Aggregate the the dataframe above at the ID to create the following claim count variables: : Number of At Fault claims Number of Not At Fault claims it should be written with python We should now have two additional columns 'at fault count' and 'not at fault count' in our aggregate dataframe
An Art Museum needs to keep track of its artwork and exhibitions. The museum has a collection of artwork. Each piece of art has a unique id [ArtID], an artist, year and title. Artwork is categorized by type. There are two types, paintings and sculptures. Paintings have a paintType and style. Sculptures have a material, height and weight. Artwork is frequently shown in exhibitions. Each exhibition has a unique name, startDate, endDate. A listing of the artwork displayed at an exhibition is also retained. Below is an E-R diagram for a database to help the Art Museum. Provide appropriate names for entities E1, E2, E3, E4 identifiers 11, 12, 13, 14 missing attributes and relationship cardinality RC1 and relationship type RT1. Start_date End_date E1 E1 11 RC1 PaintType Style E3 13 A1 Title Year A/ A A/ A/ A/ A/ A/ A/ A A/ A/ E2 12 A/ E2 E3 E4 11 12 13 14 A1 A2 RC1 RT1 RT1 A2 Height Weight E4 14 Activate Go to Settin
In this database we have users that can be two types students or instructors. They have groups and memberships. Any user can post and the post type can be video, photo or text. Here is the table structure: CREATE TABLE USER_ ( USER_ID INT NOT NULL AUTO_INCREMENT, CREATE_DATE DATE NOT NULL, PROF_DESC VARCHAR (100), PROF_PIC VARCHAR(40), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (USER_ID) ); CREATE TABLE USER_INFO( USER_ID INT NOT NULL, SU_EMAIL CHAR(18), USER_FNAME VARCHAR(15), USER_LNAME VARCHAR (15), USER_DOB DATE, USER_GENDER CHAR(1), PRIMARY KEY (USER_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE STUDENT ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, YEAR_ VARCHAR (10), MAJOR VARCHAR (20), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (SU_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE INSTRUCTOR ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, DEPARTMENT VARCHAR (40), INSTR_TYPE VARCHAR (40),…
Make use of Windows Presentation Foundation (WPF) to develop a Stock Management System thatwill manage the items being stocked in a warehouse. The application has 3 modules named: Addproduct, List Product, and Print Bar Code.Add Product:This module is used for adding new products to the system. It will require some basic details likeProduct category, Product Name, cost price, selling price, quantity and bar code. The details willbe saved into a SQL database named StockSystemdb. One other interesting feature of this systemis the alert system.You can set a particular quantity for each item. Now a notification or alert will be given to the userif a particular item’s quantity gets below the set quantity. This will help the user in gettingnotifications of the items getting low in stock.List Product:This module lists all the items present in the database of the Stock Management System. It will haveoptions to edit the details of each item or delete a particular item from the list.Print Bar…
A manager has a list of items that have been sorted according to an item ID. Some of them are duplicates. She wants to add a code to the database that assigns a 1 to the item if it is unique, and if there are duplicates, assigns the number of the duplicate. An example is shown below. The first two items are unique, so the repeat code is 1. However, Item ID 37695 is listed six times, so the codes are assigned from 1 to 6, and so on. Explain how to assign the correct code using an IF statement Item ID Repeat Code35080 135222 137695 137695 237695 337695 437695 537695 637712 137722 137757 137757 2 In cell B2 enter 1, and then type a formula into cell B3, followed by dragging the formula down column B until it aligns with the last row in the Item ID column. Which of the following is the correct formula to type into cell B3?
A key for this database is {Departure Time}. Enter a different key for the database. Airline Flight Number Gate Destination Departure Time FlyRight 221 34 Denver 08:27 JetGreen 222 13 Anchorage 08:43 JetGreen 199 22 Honolulu 08:46 JetGreen 322 34 Anchorage 09:36 FlyRight 122 33 Honolulu 09:45 FlyRight 323 22 Detroit 09:50 FlyRight 222 33 Denver 09:55 Key: { Ex: Gate
An index may speed up queries, but it's usually a terrible idea to create an index for every property or combination of properties that might be used as search keys. I'd want to know more about this.