Components of a database application are you likely to need

Assignment Help Database Management System

Reference no: EM133398577

Assignment:

Suppose you are a logistics planner for a consumer electronics company. You are responsible for delivery of materials needed to the sites for trade shows. Trade shows happen though out the year and you keep a calendar of each one your company participates in. Generally, four weeks before each show, you meet with the marketing managers and determine what displays and equipment they will need on site for each upcoming trade show. Your job is to identify each of the components that needs to be shipped and schedule a shipper to deliver them to the trade show site on time for assembly into a booth. Once the show is over, the booth materials and all equipment is shipped back to your home office. When the equipment arrives, you check it into your warehouse to ensure that all pieces of the booth and all equipment are returned. If there are problems due to shipping damage or loss, you handle those problems. The shipments include both the booth components and the equipment that will be displayed in the booth. (Booth components are the walls, carpet display racks, monitors that make up the trade show booth.)

You will need to track data about booth components, equipment, shippers, and shipments. List the tables you would use in a relational database application and identify typical fields for each type of data (include primary and foreign keys.)
Could you use a spreadsheet to keep track of this data? What would be the advantages and disadvantages of doing so?
Using your answer to question 1, give an example of two relationships that you need to track. Show the keys and foreign keys for each.
Which of the following components of a database application are you likely to need: data entry forms, reports, queries, or application program? Explain one use for each that you will need.
Will your application be for one user or for multiple users? Will you need a personal DBMS or an enterprise DBMS? If a personal DBMS, which product will you use?

Reference no: EM133398577

Questions Cloud

Does fbis request to the cell carriers constitute a search : Does FBI's request to the cell carriers constitute a search? Why or Why not? Remember, we are talking about "search" in the privacy/constitutional sense.

Explain why having the access of bootloader : Briefly explain why having the access of bootloader could be utilized for changing/bypassing the root password protection of your Operating System.

How are plicker card used in the classroom : How are plicker card used in the classroom? Why do you think plickers would be beneficial in the classroom?

How old is the device you use most frequently : How old is the device you use most frequently? Do you feel like it is out-of-date and missing features you would like to have?

Components of a database application are you likely to need : Which of the following components of a database application are you likely to need: data entry forms, reports, queries, or application program?

Examine a business continuity plan : Senior management at Health Network has decided they want a business impact analysis (BIA) that examines the company's data center.

What restrictions and policies should employers institute : What restrictions and policies should employers institute, and why? Are their risks to employees with BYOD in the workplace, if so what?

Create a plot of the residuals versus the fitted values : In addition, create a plot of the residuals versus the fitted values. What does this plot tell you about the reasonableness of using a linear model here?

Identify suitable entity sets : That means that you have to identify suitable entity sets, relationship sets, attributes, keys of entity sets (if not specified), and so on.

User Account

All Pages