Build an entity relationship model for the above scenario

Assignment Help Software Engineering

Reference no: EM13187322

Question

A military information system on a base overseas tracks personnel on the base. Each military member is tracked by ID#, name, rank, and address. Each military member belongs to an organization on the base which has an organizational name, located in a building on the base and has a primary function (e.g. Communications Squadron). Each of these organizations is also commanded by one of the military members . In tracking command sponsorship each military member may have one or more dependents. Each dependent has an ID#, name, age, and sex. Each organization on the base is involved working issues or projects which may be of interest to the base commander. Each organization also belongs to a command which has a location and a unique numerical designation. The Organization's projects are tracked by a serial number and an origination date. The information system you are designing will also track descriptions of the projects and their close-out dates.

Build an entity relationship model for the above scenario. Show all attributes and indicate all of your key attributes in red.

Reference no: EM13187322

Questions Cloud

Explain the impact of the event on the market for gasoline : as a result of increased tension in the middle east, oil production is down by 1.21 million barrels per day-a 5 percent reduction in the world's supply of crude oil explain the likely impact of this event on the market for gasoline and the market ..

Words weathering and erosion are synonyms : The words weathering and erosion are synonyms; they can be used interchangeably. Graywacke and conglomerate are examples of well-sorted rocks; shales and fine-grained sandstone are examples of poorly sorted rocks.

State how many kilograms of water would be evaporated : what fraction of the day's energy does walking one hour represent? How many kilograms of water would have to be evaporated if this were the only means of heat loss?

How much money would a typical consumer save each month : You are an assistant to a senator who chairs an ad hoc committee on reforming taxes on telecommunication services. Based on your research AT&T spends $15 million on related paper work and compliance costs. Depending on the locale, telecom taxes ca..

Build an entity relationship model for the above scenario : Build an entity relationship model for the above scenario. Show all attributes and indicate all of your key attributes in red.

What is the most logical past environment : What is the most logical past environment to have produced a deposit consisting of very little sand and mud, but instead lots of broken-up carbonate shells of marine organisms?

What is the equilibrium level of real gdp : Real GDP Consumption Planned Investment Government Purchases Net Exports $1,000 $1,000 $100 $150 -$50 2,000 1,900 100 150 -50 3,000 2,800 100 150 -50 4,000 3,700 100 150 -501) Using the table above, answer the following question. The numbers in the t..

Explain the combustion of oxalis acid in a bomb calorimeter : The combustion of oxalis acid in a bomb calorimeter yields 2816 J g^-1 at 25 degrees Celsius. Calculate a) Delta (c) U degrees and b) Delta (c) H degrees

Which is not a factor to consider in software evaluation : Which is not a factor to consider in software evaluation and peer reviewers are the key participants in which activity - Peer reviewers are the key participants in which activity?

User Account

All Pages