Question:
Soccer Mom
SoccerMom Company sells a patented seat that spectators can take to youth soccer games. The seat folds so it is small enough to fit in the glove box of most vehicles. The company operates a factory in Kansas and also contracts its manufacturing projects to small firms in Canada and Mexico.
An unusual problem has occurred for this small multinational company: People are getting confused about dates in internal memos, purchase orders, and email. Towson Hopkins handles all IT functions for SoccerMom. When he designed the company’s database, he was not aware that the format for dates in Canada and Mexico was different from the format used in the United States. For example, in Canada and Mexico, the notation 7/1/15 indicates January 7, 2015, whereas in the United States the same notation indicates July 1, 2015. Although it seems like a small point, the date confusion has resulted in several order cancellations.
Towson has asked for your advice. You could suggest writing a simple program to convert the dates automatically or designing a switchboard command that would allow users to select a date format as data is entered. You realize, however, that SoccerMom might want to do business in other countries in the future. What would be the best course of action? Should SoccerMom adapt to the standard of each country, or should it maintain a single international format? What are the arguments for each option?
Tip Top Toys
Olivia is the database manager at Tip Top Toys, a relatively small division of Worldwide Enterprises. Worldwide has nine other divisions, which include insurance, healthcare products, and financial planning services, to name a few.
Riccardo, corporate marketing director for Worldwide, has requested Tip Top’s customer shopping data to target people who might be likely to purchase items or services from other Worldwide divisions. Olivia is not totally comfortable with this, and pointed out Tip Top’s web privacy policy, which states “Tip Top Toys, a division of Worldwide Enterprises, will not share personal data with other companies without a customer’s consent.”
Riccardo replied that the statement only applies to outside companies — not other Worldwide divisions. He said he checked with the corporate legal department, and they agreed. Emily responded, “Even if it is legally OK, it’s not the right thing to do. Many people take our statement to mean that their data does not leave Tip Top. At the very least, we should give customers a choice, and share the data only with their consent.”
Do you agree with Olivia? Why or why not?
Answer:
Solution :
As per Chegg guidelines am answering only one question.sorry for the inconvenience occurred. Thank you sir...!
Using of timestamp for storing date in database would be best because it can easily be converted back to date-time format and date-time format can also be converted to timestamp
Conversion of date-time to timestamp in java ;-
String input = "2007-11-11 12:13:14" ; \\if input date is given in string java.sql.Timestamp ts = java.sql.Timestamp.valueOf( input ) ; \\simply convert date-time into timestamp
Conversion of timestamp to date-time in java ;-
Timestamp stamp = new Timestamp(System.currentTimeMillis()); \\ this is the current timestamp of user system Date date = new Date(stamp.getTime()); \\ timestamp conversion into date
Maintaining date and time format would be difficult and hard to maintain so better single datatype for storing date and time which can be converted back to time also so no more confusion at all.