Question 1. (30 points) Compute the amount of storage needed for the following. Show your work, and display all your final answers to three significant digits of precision. a. The text of a 5-page mem

Management Information Systems Homework 2 Due date: 3rd, October , 2019 (Beginning of Class) Instructor: Joonhee Lee [No grade will be given if your solution is not stapled] Late H W: Must be submitted by noon, 4 th, Octo ber, 2019 (-20 points) Q2 -Q4 Instructions : For each of the situations, design a database to hold the specified information drawing an entity -relationship (ER) diagram and writing a database design outline for the database required to hold the information described in the problem. A database design outline is a description of a database using the following notation (shown here for an example we used in class). Primary key fields must be underlined and foreign keys annotated with " attribute foreign key to TABLE". CUSTOMER( CustomerID , FirstName, LastName, StreetAddress, City, State, Zip, Phone) LOAN( LoanID , Date, Loan Amount, Rate, Term, Type, CustID) CustID foreign key to CUSTOMER PAYMENT( LoanID , PaymentNumber , Date, PaymentAmount) LoanID forei gn key to LOAN In your answers, all tables must have a primary key; you may add synthetic -key "ID" fields to tables whenever necessary. An entity -relationship (ER) diagram means a graphical depiction of the database structure as given in class. For the example above, the diagram would be as follows: In each question below, assume that any " address information " specified is in U.S. format, consisting of fields for street address, city, state code, and zip code. Assume that you do not have the master zip code table in your databases, so that city, state, and zip code may be treated as independent. Note that any text in the diamonds (such as "takes out" and "made on" above) is essentially a comment relating the database structure to the business situat ion, so exactly what you write in the diamonds is not critical. When the problems specify that you should store a " date/time ", assume that you will store dates and times together in MS -Access -style "date/time" fields. You can submit your solution as a group of up to 3 people. All solu tions must be handwritten . Question 1. (3 0 points) Compute the amount of storage needed for the following. Show your work, and display all your final answers to three significant digits of precision. a. The text of a 5 -page memo with an average of 85 characters per line and 50 lines per page. Express the result in binary -style KB. b. The BOOK table has following attributes.  An ID number ( number/integer; this field should be the primary key)  Author name (short text/120 characters )  Book name (short text/255 characters )  Publication year (number/integer)  Pages (number/long integer)  Category (short text/25 characters ) which contains 1153 book s record . Express the result in binary -style KB. c. A 8 x 10 inch photo scanned at 600 dots per inch (dpi) with 24 -bit color. 1) Express you r answer in binary -style MB. Suppose that your compression al gorithm attains a compression factor of 200. 2) How many binary -style KB would the picture consume after compression? d. 80 minutes of "1080p30" high definition video: 1920 x 1080 pixels, 24 bits per pixel, and 30 frames per second (disregard any accompanying a udio). Express your answer in binary -style GB. e. A single -layer "Blu -Ray" disc holds 25 binary GB of data. What compression factor is needed to store the video from part (d) on a Blu -Ray? Q uestion 2. (20 points) Your firm maintains gated parking lots, each with its own code ("Yellow " or “Red ” for example), number of spaces, and description (example: "behind main manufacturing facility"). Each employee has regular permission to park in exactly one parking lot. For each employee, you want to store a first name, middle name/initial, last name, home address information, date hired, office phone number, cell phone number, and e -mail address. Each employee may own one or more vehicles, and has permission to pa rk any of these vehicles in his or her designated lot. For each vehicle, you want to store the license plate number, the state in which vehicle is registered (using standard two -letter codes), the make, model, year, and color. Question 3 . (20 points) You operate a franchise restaurant operation, which a variety of partnerships and smaller companies operating restaurants using your national brand name. For each of these franchisees, you want to keep their name, address information, tax ID(which is uniqu e), and phone number. Each franchisee can have one or more contracts with you; for each contract, you want to store its start date, end date, and monthly payment. Each contract covers one or more restaurants; for each restaurant, you want to track its addr ess, date opened, date of last inspection, and seating capacity. Question 4. (30 points) You operate the PC computer support group for a medium -sized company. You wish to keep records of the time your group spends servicing various personal computers within the firm. Each company -owned PC is identified by a unique property tag number; in add ition, you want to record the PC's make and model, the room number where it is located, and the date it was acquired. Each computer "belongs" to a department of the company, identified by a department code. Each department also has a name. Some departme nts have only a few computers, but some have as many as a hundred. Every time one of your technicians services a computer, you want to record which computer was serviced, which technician performed the service, the date/time the service started, the date/ time it ended, and a description of the work performed. Each technician is identified by an employee ID number; for each technician, you also want to store their first name, middle name/initial, last name, and date hired.