Question: Review different components and models that may be implemented into a Database Management System (DBMS) for the most effective result at a particular company. Consider

Review different components and models that may be implemented into a Database Management System (DBMS) for the most effective result at a particular company. Consider which components should be used and how. For each of the following scenarios, select the kind of DBMS that you think would be most useful. Explain your reasoning and the components of the relevant designs (such as data model, data manipulation type, and so on):

Scenario A: the company has a great deal of external and internal data that must be accessed randomly.

Scenario B: the company has primarily internal data that must be accessed sequentially.

Make sure to include a description of the functions of each DBMS component, including storage capability.

You must reference two quality, peer-reviewed journal articles in your assignment.

Step by Step Solution

★★★★★

3.47 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

There are several types of components in the database management system which are as follows 1Data It is regarded as the most important component of DBMSThe main purpose of DBMS is to process the data ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Which theory do you think would be most useful for helping managers become more effective? Explain the reason for your choice.

Each of the following scenarios is independent. All cash flows are after-tax cash flows. Required: 1. Patz Corporation is considering the purchase of a computer-aided manufacturing system. The cash...

How would each of the following changes tend to affect aggregate payout ratios (that is, the average for all corporations), other things held constant? Explain your answers. a. An increase in the...

Bonadio Electrical Supplies distributes electrical components to the construction industry. The company began as a local supplier 15 years ago and has grown rapidly to become a major competitor in...

Suppose you make napkin rings by drilling holes with different diameters through two wooden balls (which also have different diameters). You discover that both napkin rings have the same height h, as...

Freeze drying is a technique for dehydrating substances at low temperatures, thereby avoiding the degradation that may accompany heating. The material to be dried is cooled to a temperature at which...

One subunit of Freeway Sports Company had the following financial results last month: Requirements 1. Complete the performance evaluation report for this subunit (round to two decimal places). 2....

We have simplified things here by separating friction (Sec. 9.7) from heat addition (Sec. 9.8). Actually, they often occur together, and their effects must be evaluated simultaneously. Show that, for...

An oxygen tank with a volume of 2.5 ft3 is kept in a room at 50F. An engineer has used the ideal gas equation of state to determine that if the tank is first evacuated and then charged with 35.3lbm...

Product costing systems and product profitability Potter Corporation has gained considerable market share in recent years for its specialty, lowvolume, complex line of products, but the gain has been...

Consider the following income statement: Sales $ 839,408 Costs 546,112 Depreciation 124,200 Taxes 22 % Calculate the EBIT.

Consider the effects on fast-food restaurants if the minimum wage is raised to $15 an hour. Is this a change in demand or supply? Which acronym for non-price determinants applies: TRIBE or ROTTEN?...

Based on Lab 2-4 Excel Sensitivity Analysis of Profitability under Changing Volume, Sales Price, and Fixed and Variable Cost Assumptions, using the Exhibit below, answer the following question. A...

Q4, 1 point for each question) Short answer questions: 1) Give an example about discretionary dependency between two activities 2) Name two inputs that you need to develop a communication plan 3)...

18. Label the graph below using the measurements of central tendency (mean, median and mode). Arrival after the scheduled class hour Histogram Count 45 40 35 30- 25 20 15 10- 5 10 8 10 Minute_late...

Q1: Outline different ways in which the restaurant can create value. Q2: Attempt to apply SWOT, VCA, and RBV to yourself and your career aspirations (lecturer). What are your major strengths and...

When a source has been retrieved through a database, what items are needed in the citation to indicate this: None of the above Name of database & access date Just the name of the database Name of...

1) The government decided to reduce taxes on fast-food to increase revenue. The government assumes that fast-food products have a) An inelastic demand b) An elastic demand c) A demand curve that is...

The narrative of Davidson Companys sales order entry process and systems flowchart of that process are shown in Exhibit 10.2 and Figure, respectively. a. Prepare a control matrix, including...

Preparing a table of entities and activities as the first step in documenting systems seems to be unnecessary and unduly cumbersome. It would be a lot easier to bypass this step and get right to the...

Indicate who you would include on a systems analysis project team in each of the following situations, and discuss fully the reasons why you would include each member you suggest.

Consider the magazine rack and its pieces shown on the following page. The raw material is 1 inch by 6 inches by 6 feet long planks of oak lumber. The 6 rails and handle are made from one plank of...

Restaurants need to plan the purchase and production of their food ingredients and components based on the forecast of demand for each meal. Consider the following example for veal picante with...

A furniture maker has received an order for 100 units of its kitchen table to be delivered at the beginning of Friday, March 20. The table consists of 1 top and 4 legs, made from purchased lumber (2"...