Reference no: EM131357849
Assignment: Database Design Discusion Post
Data Retrieval
Part 1:
Discuss why SQL is the preferred method of data retrieval in a database management system.
Part 2: Respond to two peer discusions
Peer 1 Bill
SQL, structure query language, was introduced to Database Management Systems in the late 1970s as Oracle. One of the reasons that SQL is preferred is because of its legacy and its most important aspect of the language is communicating with relational databases. In the earlier days, it was a race to improve databases management software as data requirements evolved. As systems in these days were more of a flat database, it was only time that made them to become more revolutionary as to require a need to navigate in a more multi-dimensional mean. SQL is able to support and manipulate databases that is comprised of large amounts of data.
Peer 2 Ted
SQL is the preferred method because when the DBM draft the SQL statement he/she can give step by step introduction as to which table or tables to look for, what attributes to retrieve from the table, and which rows on the table or table to look at as well. Plus the SQL keywords work across various platforms such as, MS Access, Oracle, MySQL Workbench, SQL Server, etc. By using SQL you cut down on the processing and the latency of your database, because you tell it exactly where to look instead of your software going through every row one at a time. This would be cumbersome if your database holds millions of records. Also, if you use a SQL query a lot you can save that query for future use so you don't have to keep creating it for certain users.
|
How does this fda regulation protect consumers
: 1. How does this FDA regulation protect consumers? 2. Why did the company voluntarily change its product name? 3. What effect did this regulation have on the company and on consumers?
|
|
Expected long run growth rate-what is the price of the stock
: A share of common stock has just paida dividend of $2.50 (D0). If the expected long run growth rate for this stock is 4 percent per year, and if investors require a 12 percent rate of return, what is the price of the stock?
|
|
Grand challenges approach to developing countries
: Compare the 21th-century gates Grand Challenges approach to developing countries health with that of the turn the 10th-century inventions of the Rockefeller/ carriage approach in the united states.
|
|
Evaluate economic problems and opportunity costs
: In this Assignment, you will evaluate economic problems and opportunity costs to make informed economic decisions to effectively use scarce resources. You will also examine factors that affect production possibilities to determine the maximum poss..
|
|
Why sql is the preferred method of data retrieval in dbms
: Discuss why SQL is the preferred method of data retrieval in a database management system. Also, if you use a SQL query a lot you can save that query for future use so you don't have to keep creating it for certain users.
|
|
What is company cost of preferred stock
: Bosio Inc.'s perpetual preferred stock sells for $97.50 per share, and it pays an $8.50 annual dividend. If the company were to sell a new preferred issue, it would incur a flotation cost of 4.00% of the price paid by investors. What is the company's..
|
|
Cross-prce elasticity between good
: Suppose that the cross-prce elasticity between good X and y is .25 and that the price of good y increases. Which of the following statement is true?
|
|
What is the component cost of debt
: Castro Chemical Company sold a noncallable bond several years ago that now has 20 years to maturity. This bond has a 9.25% annual coupon, paid semiannually, sells at a price of $1,075, and has a par value of $1,000. If the firm's tax rate is 40%, wha..
|
|
Determine the least-squares regression equation
: City government has collected the following data on annual sales tax collections and new car registrations: Determine the following: The least-squares regression equation
|