An unusual problem has occurred for a small multinational company: People are getting confused about dates in internal memos, purchase orders, and email. When the company’s database was originally designed, the designer 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/19 indicates January 7, 2019, whereas in the United States the same notation indicates July 1, 2019. Although it seems like a small point, the date confusion has resulted in several order cancellations. How would you fix this issue in the database?

An unusual problem has occurred for a small multinational company: People are getting confused about dates in internal memos, purchase orders, and email. When the company’s database was originally designed, the designer 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/19 indicates January 7, 2019, whereas in the United States the same notation indicates July 1, 2019. Although it seems like a small point, the date confusion has resulted in several order cancellations. How would you fix this issue in the database?

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Similar questions

You have been tasked with creating a database solution for a local library. This database will be used to keep information about the books owned by the library and which books are checked out by customers. You are given the following information: The database will need to store information about books, authors, and customers. Books can have multiple authors. Authors can write multiple books. Customers can check out any number of books they wish. Book information includes title, author, year of release, number of pages, genre, location (in library, checked out). Author information includes name. Customer information includes name, age, phone number, join date, and books checked out. Instructions: with the selected scenario in mind, create an ERD Diagram showing the tables and fields needed. Be sure to identify any keys or constraints. Write a brief prompt discussing the design considerations of your database solution.
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…
You are asked to design a database for an University. This particular university has multiple departments. Each department in that university offers one or more courses to the students. All the students are part of a certain department and they take courses in that department. A department has a name, unique number and chairman. The courses have a name, a course number such as ‘311’ , a credit point value, and the year it commenced. A course cannot be identified uniquely with the course number, but the course number is unique for each department. Students have given names, surname, unique Student ID, Date of Birth and the year they enrolled. When a student takes a course the year and the semester he or she took that particular course is recorded. When he finishes the course , the grade and total marks are recorded. A student can take multiple courses but they are also allowed to drop a semester in that university by taking no courses. Construct an ER diagram using the requirements…
in pharmacies in Turkey, it was decided to use a shared database. You have been assigned to design a database. You are given the following information:Patients are identified by their personal number and you need a record of their first name, last name, address and age. Each patient is assigned a primary doctor (family doctor).Doctors check the patients. They are identified by their registry numbers. You also need their first name, surname, specialty and years of experience. Every doctor has at least one patient. Doctors prescribe medication for patients. A doctor may prescribe one or more medications for several patients, and a patient may receive prescriptions from several doctors. Each prescription has a date and an amount associated with it. If a doctor prescribes a medicine more than once for a patient, all prescriptions must be kept.Each pharmaceutical company is identified by name and has a telephone number. Trade name and formula should be recorded for each drug. Each drug is…
module 10 An unusual problem has occurred for a small multinational company: People are getting confused about dates in internal memos, purchase orders, and email. When the company’s database was originally designed, the designer 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/19 indicates January 7, 2019, whereas in the United States the same notation indicates July 1, 2019. Although it seems like a small point, the date confusion has resulted in several order cancellations. How would you fix this issue in the database?
in pharmacies in Turkey, it was decided to use a shared database. You have been assigned to design a database. You are given the following information:Patients are identified by their personal number and you need a record of their first name, last name, address and age. Each patient is assigned a primary doctor (family doctor).Doctors check the patients. They are identified by their registry numbers. You also need their first name, surname, specialty and years of experience. Every doctor has at least one patient. Doctors prescribe medication for patients. A doctor may prescribe one or more medications for several patients, and a patient may receive prescriptions from several doctors. Each prescription has a date and an amount associated with it. If a doctor prescribes a medicine more than once for a patient, all prescriptions must be kept.Each pharmaceutical company is identified by name and has a telephone number. Trade name and formula should be recorded for each drug. Each drug is…
in pharmacies in Turkey, it was decided to use a shared database. You have been assigned to design a database. You are given the following information:Patients are identified by their personal number and you need a record of their first name, last name, address and age. Each patient is assigned a primary doctor (family doctor).Doctors check the patients. They are identified by their registry numbers. You also need their first name, surname, specialty and years of experience. Every doctor has at least one patient. Doctors prescribe medication for patients. A doctor may prescribe one or more medications for several patients, and a patient may receive prescriptions from several doctors. Each prescription has a date and an amount associated with it. If a doctor prescribes a medicine more than once for a patient, all prescriptions must be kept.Each pharmaceutical company is identified by name and has a telephone number. Trade name and formula should be recorded for each drug. Each drug is…
Bundoora College has a small book store that opens for students, staff and general public. Currently, they use a manual order system. The manager asked you to build a database for them. You had an interview session with him and you get a general overview about the database requirements. The database should store: Orders information made by students, staff or general public. The order should have order number, the date and the time it is made. Customers details, so that the manager can notify the customers with the order status as well as send promotional material. The detail includes customer code, the full name, home address, contact phone number, and email address. List of the items in each order. The items can be books and/or stationeries. For each book, you should be able to include the details such as the title, the authors, the ISBN, and the price. For stationery, you should have the code, description, and price. If a book is required for a particular subject offered in…
in pharmacies in Turkey, it was decided to use a shared database. You have been assigned to design a database. You are given the following information:Patients are identified by their personal number and you need a record of their first name, last name, address and age. Each patient is assigned a primary doctor (family doctor).Doctors check the patients. They are identified by their registry numbers. You also need their first name, surname, specialty and years of experience. Every doctor has at least one patient. Doctors prescribe medication for patients. A doctor may prescribe one or more medications for several patients, and a patient may receive prescriptions from several doctors. Each prescription has a date and an amount associated with it. If a doctor prescribes a medicine more than once for a patient, all prescriptions must be kept.Each pharmaceutical company is identified by name and has a telephone number. Trade name and formula should be recorded for each drug. Each drug is…
Your task is to develop a database, in order to keep information on all sales at a motorcycle dealership. The database will include information on motorcycles, salespeople, sales, and customers. We assume for simplicity that the dealership sells only new motorcycles and that all motorcycles are produced by the same manufacturer. Each kind of motorcycle is called a model, and it has a unique model number. For each model, you want to store also its name, engine size in cubic centimeters (cc) which is an integer number, and the date when this particular model was introduced. For each salesperson, you want to store their employee ID number, first name, middle initial, last name, and the date when the employee was hired. For each customer, you want to store a customer ID number, first name, middle initial, last name, address information (city, state, and zipcode), phone number (given in standard US format), and e‐mail address. Assume that you do not have a zip code table available. Each…
A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (CIT 170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, CIT 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class number…
Study the scenario and complete the question(s) that follow: JavaFX and Database ProgrammingPearson Institute of Higher Education (now Eduvos) has clinics on each of their 12 campuses. When a student goes to the clinic to receive medical attention, they need to be registered when it is their first time. Currently, they write the student details on paper and keep the details in physical files. Pearson management has contacted you to digitise the process of registering new patients at the clinics. They would like an application developed which will enable the clinic staff to register the patient digitally. The patient records should then be saved to a database. Create a JavaFX application using NetBeans for the Pearson Clinic. The application should have/do the following: 1. A graphical user interface (GUI) that will allow the user to enter the following details: Patient Name, Patient Surname, Patient ID Number, Patient Cell Number, Patient Student Number.2. The GUI should have an…