24. A view is which of the following? A) virtual table that can be accessed via...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
24. A view is which of the following? A) virtual table that can be accessed via SQL commands B) virtual table that cannot be accessed via SQL commands C) base table that can be accessed via SQL commands D) base table that cannot be accessed via SQL commands 25. does not have a distinguishing attribute of its own, and its existence depends on another entity. A) Weak entity B) Strong entity Non attributes entity D) Dependent entity II. Short Answer (50 pts) 26. (15 points) Construct an E-R diagram for a car insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. Note to specify the multiplicity for each relationship. For each entity, specify the attributes and the primary key. show stubong yan 24. A view is which of the following? A) virtual table that can be accessed via SQL commands B) virtual table that cannot be accessed via SQL commands C) base table that can be accessed via SQL commands D) base table that cannot be accessed via SQL commands 25. does not have a distinguishing attribute of its own, and its existence depends on another entity. A) Weak entity B) Strong entity Non attributes entity D) Dependent entity II. Short Answer (50 pts) 26. (15 points) Construct an E-R diagram for a car insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. Note to specify the multiplicity for each relationship. For each entity, specify the attributes and the primary key. show stubong yan
Expert Answer:
Answer rating: 100% (QA)
answer 24 C Base table that can be accessed via SQL commands 25 A Weak entity 26 Entities Customer Customer ID Primary Key Name Address Phone Number C... View the full answer
Related Book For
Systems analysis and design in a changing world
ISBN: 978-1423902287
5th edition
Authors: John W. Satzinger, Robert B. Jackson, Stephen D. Burd
Posted Date:
Students also viewed these electrical engineering questions
-
A privative clause is which of the following a) the privative clause refers to the section of the charter of rights and freedoms that prevents the charter from applying to private or nongovernmental...
-
Which of the following does not accurately summarize auditors requirements regarding internalcontrol? Public EtityNonpublic E a. Understanding b. Documenting c. Evaluating control risk d. Test...
-
Which of the following does NOT accurately describe homologous pairs of chromosomes? Homologous chromosomes code for the same genes. Homologous pairs contain one chromosome inherited from the father...
-
For the couple-stress theory, show that the two stress functions satisfy: = 0= +-zd'0=+
-
Dylan Mays is auditing the accounts receivable of Channel Company. Channels accounts receivable were recorded at $ 2,000,000 and comprised more than 1,500 customer accounts. However, Channels 10...
-
Depreciation ComputationsFive Methods Wenner Furnace Corp. purchased machinery for $279,000 on May 1, 2010. It is estimated that it will have a useful life of 10 years, salvage value of $15,000,...
-
In 2010, in an attempt to increase the number of Americans covered by health insurance and reduce the cost of health care, Congress passed the Patient Protection and Affordable Care Act. A key...
-
The Money Pit Mortgage Company is interested in monitoring the performance of the mortgage process. Fifteen samples of five completed mortgage transactions each were taken during a period when the...
-
Database design is quite complex and important. Discuss the role played by users during the design process Describe the purpose of normalizing data Briefly describe the basic SQL DDL statements and...
-
Refer to Figure 11.45. A square footing, 2 x 2 m in size, supports a column load of 300 kN. The soil characteristics are given in the figure. Field monitoring indicated that the foundation settlement...
-
Regarding the difficulties that developing countries face in achieving higher standards in food safety, what is your opinion about the lack of consumer awareness? Do you think that it may influence...
-
8. Orbit of the Earth. Assume that the Earth orbits the sun in a circle with radius 93,000,000 miles, that is circular motion. If a year is 365 days, how fast is the Earth traveling in its orbit?...
-
4. The average American last year worked 44 hours per week and a population standard deviation of 7 hours. What percentage of people work at least 50 hours per week? What percentage of people work...
-
You have a 0 . 4 8 7 kg sample of gas containing 2 . 0 3 mol. you measure the gas's temperature to be 7 4 . 1 degrees celsius. Determine the gas molecules' rms speed vrms . . Determine the gas...
-
PROBLEM 1: On January 1, 2021, Vim Company purchased an equipment for P3,000,000.00 cash for the purpose of leasing it. The machine is expected to have a 10-year life from the date of purchase. On...
-
What is the average percent growth per year for Q if logQ=3+0.0294t where t=time (in years)? (Example: if the growth rate is 0.04 or 4 percent, express theanswer as 4)
-
Observe the balance sheet give below of Jindal steel and power limited and give an Explanation by observing the changes happening in: 1. Fixed assets 2. depreciation 3. Cash equivalents 4. loans and...
-
1. Using the information from Problem 16-4B, prepare a statement of cash flows for Lim Garden Supplies Inc. using the direct method of presenting cash flows from operating activities. 2. How does Lim...
-
Develop a recommended implementation approach for RMO. Also develop a presentation of your recommendation to upper management.
-
1. Develop a use case diagram. 2. Create fully developed use case descriptions for two of the primary use cases, such as recording traffic ticket and Scheduling a court date. 3. Develop system...
-
What are attributes and compound attributes?
-
Approximately 50,000 new titles, including new editions, are published each year in the United States, giving rise to a $25 billion industry in 2001. In terms of percentage of sales, this industry...
-
When you think of political persuasion, you may think of the effortsthat political campaigns undertake to persuade you that their candidate is betterthan the other candidate. In truth, campaigns are...
-
Exeter, Inc., is a catalog firm that sells products in a number of different catalogs that it owns. The catalogs number in the dozens but fall into nine basic categories: 1. Clothing 2. Housewares 3....
Study smarter with the SolutionInn App