Grading Rubric英文代做、代做database php, c# adsp.net 程序assignment

日期：2018-08-02 02:41

Point deductions are given in percentages.  

Late policy of 4% per day late and using good object oriented coding still apply.

Copying code from the internet does not count as writing your own code.  Do not do this.

A good way to check your code is to use the test script provided.

Because the second part of this project is dependent on the first part, the point deductions from part 1 will apply in addition to what is listed here.  

There are five parts of this part of the project:

Adding a new flight, canceling a booking for a specific customer and flight (we assume each customer will at most be booked on one flight per day), adding a new day, checking the status for a particular customer, and dropping a flight.

Because the last assignment must be graded very quickly for final grades, it is very important that you submit the database and project as directed.

Database and project considerations:

?When you submit your project, you MUST submit both your code and your database (-5 if you fail to submit your database when you submit your code.  We need it to grade your assignment.)

?You need to close your project before you zip the database otherwise the graders will receive errors when they grade it.  

?You must submit the zip of your entire Netbeans project instead of just the .java files this time

?Your database should have the username and password of ‘java’ and ‘java’ as per the directions

?ALL tables in your database must be EMPTY (-5 for not following these directions)

?Make sure you name your project folder and database with your name or user id

Functionality:

?Correctly adding a flight to the database (-10)

oMust include flightname and number of seats

oYou may use number spinner or textfield to enter the number of seats

?Correctly adding a new day to the database (-10)

oThe days can be in Date or Varchar format in the database

oIf you accept strings for your days, make sure you give the user directions on what format to enter

?Correctly checking status by customer  

oMust display flight customer is booked for (-3)

oMust display flights customer is waitlisted for (-3)

oMust be able to look up customer only by name (-3)

?Drop flight

oRemove flight from database (-3)

oCustomers on this flight must be rebooked on another flight for the day(s) they were originally booked (-8)

oCustomers should be booked based on priority (their timestamp) (-2)

oCustomers on waitlist should be deleted (-3)

oIf customer can’t be added to any flight, they should not be added to any waitlist (-3)

oUser should be informed of all actions (see below)

?Cancel Booking (cancel customer day)

oRemove booking or waitlist corresponding to that customer and day from the database (-3 for each booking and waitlist)

oMust cancel booking by customer and day only (should not include flight number) (-3)

oChecking waitlist and booking another customer for that day and flight (-5)

oCustomers from waitlist must be booked in order of their position (timestamp) (-3)

GUI:

?You can have a separate tab for each function, or you can combine multiple functions on the same tab.  The big thing is that you have all pieces of functionality.

?You should have combo boxes to check customer status, drop flight, cancel customer day, etc (-2 for each combo box missing)

?The combo boxes should be updated automatically when additional data is added to the database (-3)

?When a command is performed, the results of that command should be displayed to the user without the user needing to check the status to see what was done.  For example, if you add a customer to the database you should display the name of the customer that was added and if the customer was added to the database successfully.  Likewise, after adding a booking, you should display which customer was booked on which flight on what day.  If a flight is full, you must display information that the customer was added to the waitlist

oYou will need to show the status for every action

?For Part 2, this means displaying to the user if a flight or day was successfully added to the database (or was not successfully added); for cancel customer day this means showing that the booking was successfully canceled, then showing which person from the waitlist was able to be added to the flight (if there is one); for drop flight, this means displaying how customers are rebooked or if they can’t be rebooked

oWhen showing the results of a command, you should display the results of that particular command, not all of the contents for the database or that table in the database