Computer Science Projects

Decision Tree Develop a decision table or a decision tree to describe the steps in the purchase of a book using a credit card from Amazon.com. Entity Relationship Diagram Develop ERDs to describe a small book publishing company.  You can use the methodology posted on COL as a guide to your process. Design Improvements & Issues Find a web site you think is particularly poorly designed and critique it using the principles we have discussed in class to explain what is wrong with it. Get Project Solution by contacting us - via WhatsApp: +92-324-7042178 - via email: codelogixstudio@gmail.com

Task 1 – Data Import Import the crimedata.sql file into your mysql server database using the PHPMyAdmin application on the LAMP server. Make sure that the import creates a crimedata table and has the following columns: crime_ID, month, reported_by, falls_within, longitude, atitude, location, LSOA_code, LSOA_name, crime_type. The explanation of each column is provided in the appendix A. If imported correctly, your table will have 66,683 records. Task 2– Unit Testing Write Unit Tests for all your classes and methods you implement in tasks 3,5, and 6. Task3 – Database Handling Create a class called DatabaseHandler. This class will have a method called handleDbConnection. It has no input parameters and returns a java.sql.Connection object. You should use your mysql credentials here to make a connection to the database that contains the crimedata table. Other methods and classes implemented as part of tasks below will call the handleDbConnection method to use the connection object a

Implement In Java the Snapshot pattern depicted In the UML diagram in snapshot.pdf file. Please pay special attention to the access modifiers (+: public, -: private or no sign: package) for each attribute and operation and implement them in Java. The UML diagram follows some of classes defined in the Snapshot pattern in book (page 371) which has more details than in my diagram. Please read the descriptions about them in the book. My MdestonefementolFhas two methods and my private static class Mllestonenemenfo has three attributes. Here are a couple of extra points you need to be aware of: • GameUserInterface class Is the program that user Interacts with. • gets user selected file through JFileChooser  Uses GameSerializer which is the action listener that serializes (saves) GameModel object Into a user-specified file.  Uses GameDeserializer which Is also an action listener that deserializes (read object) from a user specified file.  Gets MilestoneMementoManager from GameModel an