I have weekly assignments that consist of interim deliverables for my final project. For the first week, I need to submit a proposal. The proposal should outline how you plan to approach completing your final project and how you plan to overcome obstacles in developing your project.

The project is the following:

The final project is a semester-long exercise that has multiple deliverables throughout the course. Each deliverable is a building block on which you will construct the final project. The approach to building the final project is an abbreviated version of how software projects are typically done in a commercial environment. The general construction steps are as follows:

Customer requirements – Initial project requirements

Systems Analysis – Development of diagrams and concept refinement

Systems Architecture – Constructing the technical framework of the system

System Development – Writing code for the system

System Testing – Testing the functionality of the system to ensure that it meets requirements and is bug-free

System Release – Submission to your instructor

Minimum system requirements:

System design documents

Tables in 3rd normal form

Look up tables

Use of stored procedures for query, insert, and delete

In code commenting

System create scripts

System data insert scripts to populate lookup tables as well as some ‘dummy’ data for the rest of the system so that your instructor may test your system

Note: It can be very easy to read too much into the requirements for any software project, so it important to contact your instructor to get clarification, if needed. If possible, please make contact through the project discussion forum so that the entire class has the benefit of the answer.

The development of the system does not require any knowledge of trucking systems. You will be building your system based on general knowledge that anyone would have about delivering cargo. (Think in terms of what you know about UPS or FexEX).

We are concerned with knowing what cargo was in a truck, who drove the truck, which truck was used, when was it delivered and some information on any truck maintenance that was done during the haul.

The below scenario greatly simplifies what would happen in a real-world scenario. There will only be one driver for the truck, only one truck will be used during a haul and only one trailer will be used for a haul.

You have been hired by Acme Software, Inc. to develop a database for its customer, XYZ Trucking. The proposed database will manage its fleet of trucks. Your task will be to do the initial design of the database that will eventually connect with a web based front end to be developed internally by Acme Software, Inc. You will not be working on the web based front end.

Concept

XYZ Trucking manages several hundred trucks. The proposed system shall manage the daily movements of trucks and drivers as well as track truck downtime due to maintenance or other unforeseen circumstances. Some fleet trucks are a single unit, without trailer, while some are tractor-trailer combination (18-wheel) vehicles that can pull varying types of trailers.

A preliminary business analysis has been done and the analyst has determined that the below data is required for the initial database system.

Minimum Required Data Elements: (Key M = Element must always have a value, L = look up table of default values). Items in ()’s are the only legal values for those fields.

Driver Demographic Information:
Name M
Date of Birth M
Employee Number M
Date of Hire
Commercial Driver License (yes or no) M

Truck Information:
Truck Type (Long or short haul) M
Truck Body Type (Tracker Trailer or Single Unit) M
Truck Number M
Truck License Number
Truck Description
Truck Engine Type
Truck Fuel Type
Truck Current Mileage M

Trailer Information (Tractor-Trailer Only)
Trailer Type (Tanker, Flat Bed, Box, Refrigerated) M, L
Trailer Capacity M
Trailer Mileage M
Trailer Description

Haul Record (Delivery Records)
Truck Used M
Client M
Cargo Type (Hazardous, Liquid, Refrigerated, Standard, Other), L
Date Haul Began M
Date Delivered M
Mileage M
Haul Notes

Haul Manifest (Inventory of items delivered)
Item M
Item Description
Item Weight Per Unit
Quantity M

Truck Maintenance
Truck M
Maintenance Start Date M
Maintenance End Date M
Maintenance Type (Engine, Transmission, Tires, Body, Electrical, Hydraulic, Pneumatic) M, L
Maintenance Code (Routine, Unscheduled) M, L

Using the minimum data elements, and any others that you determine are necessary, build a prototype database system. The user interface being developed by Acme Software shall use stored procedures developed by you to access data in the database. All data manipulation (insert, update, delete, and query) shall be done through your stored procedures.

Business Logic

The basic business logic of the system shall be included in the database’s stored procedures. Design of the logic will require some systems analysis in order to ensure that the logic is correct.

A driver shall always be associated with a haul. (This means that whenever there is data inserted into the haul tables, the driver ID must be included in that data.)

A truck that is a tractor-trailer combination shall always be associated with trailer information.

If a truck has a maintenance date that is between a begin haul date and delivery date, that information must be included in the Haul Notes. (This one is a bit more complex because the stored procedure that inserts a haul record must have logic to check the maintenance tables(s) to see if that truck has scheduled maintenance due between the beginning date and end dates for that haul. If so, the record inserted into the haul table(s) must include a note on that maintenance in the Haul Notes column of the table.) NOTE: This logic is optional for the final project.

Report stored procedures:

Truck Maintenance: The stored procedure shall accept a date range for the report and shall include the truck number, maintenance done, and shall be ordered by long haul, short haul and maintenance date.

Haul Record:The stored procedure shall accept a truck number and date range. The stored procedure shall return the haul record of the truck in chronological order but not include detailed inventory.

Haul Inventory: This stored procedure is similar to Haul Record, except it shall also include the detailed haul inventory.

Custom Report: Develop one other report of your choosing.

Ship-Builders Co. began construction of a new cutter for the U.S. Coast Guard on January 1, 2018 and completed construction of the ship on March 31, 2019. To help finance construction, Ship-Builders took out an $8,000,000, 2-year, 7% loan on January 1, 2018. Interest on the loan was to be paid annually at the end of each year and the principal at the end. Ship-Builders has no other outstanding interest-bearing debt. Ship-Builders made the following expenditures in conjunction with this construction project:

How much interest should Ship-Builders Co. capitalize in 2018? How much should they expense in 2018?

Is globalization primarily a positive or a negative force in the world? From what you have learned about the effects of globalization so far in the course, what do you think is the SINGLE most compelling argument for or against globalization and why? Illustrate your argument with specific empirical evidence and examples. What can you do personally to help ensure globalization is a force for good? Explain and provide ONE example of a way you can make a positive difference as a citizen of a globalizing world.

The weight of an organ in adult males has a​ bell-shaped distribution with a mean of 350 grams and a standard deviation of 35 grams. Use the empirical rule to determine the following. ​(a) About 99.7 of organs will be between what​ weights? ​(b) What percentage of organs weighs between 280 grams and 420 ​grams? ​(c) What percentage of organs weighs less than 280 grams or more than 420 ​grams? ​(d) What percentage of organs weighs between 245 grams and 385 ​grams?

The Acme Company manufactures widgets. The distribution of widget weights is bell-shaped. The widget weights have a mean of 60 ounces and a standard deviation of 7 ounces.

Use the Standard Deviation Rule, also known as the Empirical Rule.

Suggestion: sketch the distribution in order to answer these questions.

a) 95% of the widget weights lie between  and

b) What percentage of the widget weights lie between 53 and 74 ounces?  %

c) What percentage of the widget weights lie above 39 ?  %

The lethal dose for caffeine according to the FDA is about 200 mg of caffeine per kilogram body mass for a human. If one serving of a Monster Energy Drink weighs 240 g and contains 86 mg of caffeine, how many servings can a 145 lb student consume before it could potentially be fatal?

Sucralose is an artificial sweetener found in many diet foods. Find the empirical formula if it is 26.748% Cl, 4.816% H, 36.247% C, and 32.1889 % O.

The Acme Company manufactures widgets. The distribution of widget weights is bell-shaped. The widget weights have a mean of 50 ounces and a standard deviation of 5 ounces. Use the Standard Deviation Rule, also known as the Empirical Rule. Suggestion: sketch the distribution in order to answer these questions. a) 95% of the widget weights lie between and b) What percentage of the widget weights lie between 45 and 60 ounces? % c) What percentage of the widget weights lie below 65 ? %

There are 68% of students drive to school in one university. Here is a sample of 20 students.

1) What is the probability that only 12 students drive to school?

2)What is the probability that no more than 15 students drive to school?

3) What is the probability that no more than 10 students drive to school?

4) What is the mean and standard deviation?

5) What is the percentage falling with 1 standard deviation? Does it satisfy the Empirical Rule?

Please explain with reasoning/steps please.