Explain use of er-assistant to depict conceptual model

Assignment Help Software Engineering

Reference no: EM1367005

1. Explain how you will go about developing this database.
2. Then, develop your conceptual model, logical model, and a few examples of what the physical model would look like. [Hint: You can use the ER-Assistant to depict the conceptual model and MS Access to depict the logical model.]
3. Using MS Access, develop the database.
a. Provide at least three forms showing a main form and a sub form.
b. Provide at least four queries that answer some of the questions asked by the end users.
4. Describe how you will deal with the following database issues:
a. Transaction management and concurrency control.
b. Performance tuning and query optimization.
c. Database administration and security.

Reference no: EM1367005

Questions Cloud

Question on market consequences of price floor : A price floor is set by the government to protect the producer of the good to which price floor has been attached. There're two possible outcomes for market in price floor setting.

Calculating expected stock price : Kirkland Motors expects to pay a $2 / share dividend on common stock at the end of the year. The stock currently sells for $20 per share. The required rate of return on corporation's stock is 12% [ks = .12].

Counseling before taking isotretinoin : A 22 year old with severe acne is receiving counseling before taking isotretinoin.

Determining equilibrium price and output : Consider the competitive market served by many domestic and foreign firms. The domestic demand for such firm's product is Qd=500-1.5P. The supply function of domestic firms is Qsd=50+.5P, while that of the foreign firms is Qsf=250.

Explain use of er-assistant to depict conceptual model : Create your conceptual model, logical model, and few examples of what physical model would look like. Hint: You can use ER-Assistant to depict conceptual model and MS Access to depict logical model.

Entrepreneurship-affecting the health care field : Describes the positive and negative ways that entrepreneurship has affected the health care field.

Question based on financial accounting : Newell Corporation debited Prepaid Insurance for $720 on July 1, 2000 for a 1 year fire insurance policy. If the corporation makes monthly financial statements,

Advertising relationship with demand : Consider two firms X and Y that produce identically tasting cold drinks. In order to raise the demand for its cold drink, firm X raise its advertisement outlay.

Write pseudo algorithm which inputs age for valid voting : Write pseudo algorithm which inputs Age, displays "Yes, you can vote" if Age is 18 or older and displays "You are too young to vote" if Age is less than 18, and displays nothing else.

User Account

All Pages