What happens if the database is poorly designed

Assignment Help Database Management System

Reference no: EM131627335

Assignment: DataBase Systems Questions

Questions: Answer each question in at least 5 sentences.

1) Why use databases? Isn't Excel enough?

2) What makes databases special?

3) What problems do databases try to address?

4) Why is a relational database an excellent way to represent and store data?

5) What happens if the database is poorly designed?

6) What are the advantages and disadvantages of the relational model?

7) Explain why the entity relationship (ER) model is useful.

8) How has the entity relationship (ER) model helped to produce a more structured relational database design environment?

9) Discuss the relationship between data redundancy and normalization.

10) What are the consequences if databases are not normalized?

11) What problems is normalization addressing?

12) Why is normalization crucial for effective database design and development?

13) Explain what SQL is and its functions.

14) What do you enjoy the most about learning SQL?

15) What you find the most difficult?

Reference no: EM131627335

Questions Cloud

Discuss contempt for the court and ridiculed his victims : Omola displayed contempt for the court and ridiculed his victims, calling them stupid for having been cheated. What does this behavior

Calculate the exercise price of the put option : Are your put options in the money, at the money, or out of money? Calculate the Exercise price of the put option.

Discuss what normalization is and why it is important : Discuss what normalization is and why it is important. Describe (in at least one paragraph) what ACID is and why it is important for databases.

What would the profit of the seller : What would the loss of the seller of the put option be if, at expiration, XLB is trading at $20? What would the profit of the seller?

What happens if the database is poorly designed : What happens if the database is poorly designed? What are the advantages and disadvantages of the relational model? What problems is normalization addressing?

Discuss letter of intent create a legally binding obligation : Did the letter of intent create a legally binding obligation, or was the letter merely an agreement to agree in the future

Interest rate caps and floors : Assess the volatility risk with an investment in a derivative, using an interest rate cap or floor in today's marketplace.

What is the breakeven point of the call option : One of the positive attributes of investing in options is the profit potential from the puts or calls. The quoted market price of the option is influenced.

What is your capital gain yield : You bought a government bond for $1000 a year later you sold the bond for $1200. The coupon during the year was $110.

User Account

All Pages