Solution-Discuss about the logical and physical design

Discuss about the logical and physical design

Assignment Help Management Information Sys

Reference no: EM131389540

"Logical and Physical Design" Please respond to the following:

In order to ensure optimal database performance, the logical and physical design should consider the user requirements thoroughly.

Suppose you have been hired to transform a conceptual model into a logical model for a sales database. Describe the specific steps that you must perform in order to appropriately construct the database model. For each step mentioned, speculate the risks that would take place and how you would avoid or mitigate those risks.

Suggest at least three activities that are required in the physical design process of a database to ensure adequate physical storage and data access. Analyze why user, security groups, and role definitions are essential to maintain the integrity of the database.

Reference no: EM131389540

Questions Cloud

Explain were the dividends wrongfully paid : Wood did not allege that the present creditors were also creditors when the dividends were paid. Were the dividends wrongfully paid? Explain.

Deciding on possible global markets to enter : What factors do companies consider when deciding on possible global markets to enter? What is sustainable marketing? Explain how the sustainable marketing concept differs from the marketing concept and the societal marketing concept?

Analyze this case by determining the factual issues : This case is a perfect instance of what we discussed previously in this chapter when we said that the factual issues can be controversial.

May fried recover the amount of these dividends from cano : May Fried, the trustee in bankruptcy of IDE, recover the amount of these dividends from Cano on the basis that they had been paid when IDE was insolvent or when its capital was impaired?

Discuss about the logical and physical design : Suppose you have been hired to transform a conceptual model into a logical model for a sales database. Describe the specific steps that you must perform in order to appropriately construct the database model. For each step mentioned, speculate the..

What is the result in given contention : The shareholders brought an appropriate action against Brown, charging that his proposal had caused the corporation a substantial loss. What is the result?

What are the ethical implications for union carbide : Some of Union Carbide's reports hinted strongly that part of the fault lay with the inadequate workforce available in a third-world country such as India. How valid is this statement? What are the ethical implications for Union Carbide if this sta..

Discuss about the data warehousing design : Create a database schema that supports the company's business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail t..

May s recover damages from x corporation : A resolution was then unanimously adopted to cancel the contract with S. May S recover damages from X Corporation for breach of contract?

User Account

All Pages

Discuss about the logical and physical design

Reference no: EM131389540

Reference no: EM131389540

Questions Cloud

Reviews

Write a Review

Management Information Sys Questions & Answers

Information technology and the changing fabric

Case study: software-as-a-service goes mainstream

Research proposal on cloud computing

Host an e-commerce site for a small start-up company

How are internet technologies affecting the structure

Segregation of duties in the personal computing environment

Social media strategy implementation and evaluation

Problems in the personal computing environment

Role of it/is in an organisation

Perky pies

Mark the equilibrium price and quantity

Visit and analyze the company-specific web-site

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT