Concepts Answers

What is infobase? Q & Answers A database is a logically co herent collecting of data with some(prenominal) inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose. 2. What is DBMS? It is a collection of programs that enables user to create and maintain a database. In early(a) words it is general-purpose softw atomic number 18 package that provides the users with the processes of defining, constructing and manipulating the database for various applications. 3. What is a infobase system?The database and DBMS softw be together is called as entropybase system. 4. Advantages of DBMS? Redundancy is controlled. wildcat access is restricted. Providing multiple user interfaces. Enforcing integrity constraints. Providing backup and recovery. 5. Disadvantage in File Processing dodging? entropy redundancy & inconsistency. Difficult in accessing data. Data isolation. Data integrity. Concurrent access is non po ssible. shelter Problems. 6. Describe the three levels of data abstraction? The be three levels of abstraction Physical level The terminal level of abstraction describes how data are stored.Logical level The next higher(prenominal) level of abstraction, describes what data are stored in database nd what relationship among those data. View level The highest level of abstraction describes only part of full database. 7. Define the integrity rules There are two Integrity rules. Entity Integrity States that P bankary key out cannot go through NULL value Referential Integrity States that Foreign Key can be either a NULL value or should be Primary Key value of other relation. 8. What is extension and connotation? Extension It is the number ot tuples present in a table at any instance.This is time dependent. intension It is a constant value that gives the form, complex body part of table and the constraints laid n it. 9. What is establishment R? What are its two major subsystem s? System R was designed and developed over a period of 1974-79 at IBM San Jose Research Center. It is a proto lawsuit and its purpose was to demonstrate that it is possible to build a relation backal System that can be used in a real life environment to solve real life problems, with performance at to the lowest degree comparable to that of existing system. Its two subsystems are Research warehousing System Relational Data System. 0. How is the data structure of System R assorted from the relational structure? Unlike Relational systems in System R Domains are not supported Enforcement of candidate key uniqueness is optional Enforcement of entity integrity is optional Referential integrity is not enforced 11. What is Data independence? Data independence means that the application is independent of the storage structure and access strategy of data. In other words, The ability to modify the schema definition in angiotensin-converting enzyme level should not affect the schema def inition in the next higher level.Two slips of Data Independence Physical Data Independence Modification in physical level should not affect the logical level. Logical Data Independence Modification in logical level should affect the descry level. NOTE Logical Data Independence is more than difficult to achieve 12. What is a view? How it is related to data independence? A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is so unmatchedr derived from integrity or more underlying base table. In other words, there is no stored file that direct represents the view instead a definition of view is stored in data dictionary.Growth and restructuring of base tables is not reflected in views. Thus the view can insulate users from the effects of restructuring and growth in the database. Hence accounts for logical data independence. 3. What is Data computer simulation? A collection of constructual tools for describing data, data r elationships data semantic cs and constraints. 14. What is E-R mold? This data model is ground on real world that consists of basic objects called entities and of relationship among these objects. Entities are described in a database by a focalise ot attributes. 15. What is Object Oriented model? This model is based on collection of objects.An object contains values stored in instance variables with in the object. An object also contains bodies of code that operate on the object. These bodies of code are called methods. Objects that contain ame types of values and the same methods are grouped together into classes. 16. What is an Entity? It is a thing in the real world with an independent existence. 17. What is an Entity type? It is a collection (set) of entities that have same attributes. 18. What is an Entity set? It is a collection of all entities of particular entity type in the database. 19. What is an Extension of entity type?The collections of entities of a particular enti ty type are grouped together into an entity set. 20. What is Weak Entity set? An entity set may not have able attributes to form a primary key, and its primary ey compromises of its partial key and primary key of its parent entity, then(prenominal) it is said to be Weak Entity set. 21 . What is an attribute? It is a particular post, which describes the entity. 22. What is a Relation dodge and a Relation? A relation Schema denoted by R(AI, A2, , An) is do up of the relation name R and the list of attributes Ai that it contains. A relation is defined as a set of tuples.Let r be the relation which contains set tuples (tl, t2, t3, tn). Each tuple is an ordered list of n-values t=(v1,v2, vn). 23. What is degree of a Relation? It is the number of attribute of its relation schema. 24. What is Relationship? It is an association among two or more entities. 25. What is Relationship set? The collection (or set) of similar relationships. 26. What is Relationship type? Relationship type det lnes a set ot associations or a relationship set among a given set of entity types. 27. What is degree of Relationship type? It is the number of entity type participating.Concepts AnswersMarginal revenue is the additional revenue that a firm obtains by selling one more unit. Marginal equalize is the cost of hiring one more unit of force or the cost of producing one more unit of output. Marginal revenue product is the additional revenue we obtain by hiring one more unit of labor. When we incur a borderline cost our hope it that is give generate marginal revenue product which exceeds the cost. Hence the marginal revenue forget exceed our marginal cost. 4. Distinguish amidst economic and financial peachy.Economic capital resources include all items that man manufactures by combining natural and unnerve resources like buildings, equipment, roads, and bridges. pecuniary capital is a dollar value claim on economic capital. Financial capital would include cash, deeds of trust, mo rtgages, loan papers, stocks, and bonds. 5. Discuss the value of the entrepreneur. What distinguishes the entrepreneur from the labor resource? why are entrepreneurs unique? Entrepreneurial resources consist of the ideas of individuals, who assume take a chance and begin business enterprises.The entrepreneur combines natural, human, and capital resources to produce a good or service that we value more than the individual components. Without the entrepreneur, the other resources would not unremarkably be combined, except for subsistence (I . E. , the resources that are scantily sufficient to sustain life). The entrepreneur seeks to make a profit when using his ideas. When we look at overall requitalments, the mental talents of people in the form of the entrepreneur normally exceed the wages that are salaried for labor. The owner of a professional sports team, the entrepreneur, will normally make more than any player on that team.Of course, the more brilliant the idea and its ult imate raise to the buyer of the good or service, he more profit that will accrue to the entrepreneur. 6. What is opportunity cost? An opportunity cost is the highest value that is surrendered when a decision is made it is never the decision, which is made. It is a quantifiable term. 7. What makes up gross income? All of the silver received from all sources during the year. This includes wages, tips, interest earned on savings and bonds, income from rental property, profits to entrepreneurs, and any other source of income an individual may have. 8.Compare progressive, regressive, and proportional taxes. Give at least one example of each type of ax. Progressive taxes are taxes that take a larger circumstances of your income as your income increases. Regressive taxes are taxes that take a higher percentage of your income as your income decreases. Proportional taxes are taxes where the percentage stipendiary stays the same, regardless(prenominal) of income. Examples include progres sive income taxes, regressive sales taxes, and proportional property taxes. 9. What is the law of supply? The law of supply states that as the payment or price of an item increases, coteries Paramus, we will supply more of that item. 0. What is a supply table? How do you obtain supply curve from a supply table? A supply table is a listing of the quantities of some variable, which will be supplied at various prices in the market place. The supply curve is obtained by horizontally summing the quantities supplied by different suppliers at each price in the market. 11. What is the law of demand? The Law of Demand states that if all other factors are constant, as the price for an item decreases, people will demand more of that item, coteries Paramus. 12. Explain the concept of a sur sum broad(a) of money versus a shortage of money.When the supply of money saved exceeds the demand for money, here is a surplus of money then institutions (banks, credit unions, savings and loans, etc. ) wil l pay less for savings, and interest rates will begin to fall. When the demand for money exceeds the supply, there is a shortage of money and interest rates will be bid up in the market as institutions attack to obtain more money. 13. What is the federal Reserve? What are the Feuds three tools for controlling the money supply? The Federal Reserve is the Central Bank of the United States.The three tools for controlling the money supply are the displace rate, the reserve requirements ratio, and federal open market operations. 4. What is risk? What is the difference between systematic and unsystematic risk? Risk involves the probability that the actual return on an investment will be different from the in demand(p) return. Systematic risk is that risk which is associated with economic, political, and sociological changes that affect all participants on a near equal basis. Unsystematic risk is that risk that is unique to an individual, firm, or industry. EXERCISES AND PROBLEMS 1.Car ry Yogis Lounge consists of the following. Carry, the owner believed that people would come to larn a band play on Friday, Saturday, and Sunday evening. During the remainder of the week, she believed her customers would watch sporting events on some(prenominal) television sets located throughout the lounge. Carry employed two bartenders, three servers, two assistant servers, two cooks, one dishwasher and a clean-up person. She had a bar, 15 barstools, 4 tables, 40 chairs, 4 television Sets, and one satellite dish. She had an oven, stove, grill, refrigerator, sinks, dishes, and glassware.Carry started this business with $50,000 of her own money, and she borrowed $1 50,000 from the bank. From this description, list each of the scarce resources that are used in Carry Yogis Lounge. Entrepreneurial resource Carry Yoke. Labor resources 2 bartenders, 3 servers, 2 assistant servers, 2 cooks, 1 dishwasher, and a clean-up person. Economic capital resources 1 bar, 15 bar stools, 4 tables, 40 chairs, 4 television sets, one satellite dish, oven, stove, grill, refrigerator, sinks, dishes, and glassware. Financial capital resources $50,000 of her own money and $1 50,000 from the bank. . Joe Fixity has an implement haunt business. He has more business than he can handle and wants to hire another repair person. Joe estimates that three appliances can be repaired each second by a qualified person. Joe bills out labor at $45 per hour, but he stipulates that the minimum charge for appliance repair estimates is $30 plus parts. What is the marginal revenue product of a qualified repair person? 3 appliance repairs per hour times $30 = $90 marginal revenue product. What is the maximum hourly wage that he would pay an employee?Therefore, since we bring in an additional $90 per hour by hiring one more repair person, the maximum wage we would pay is $90. 3. Sam Smith is currently employed as a mechanical steer and is paid $65,000 per year plus benefits that are equal to 30% of hi s salary. Sam wants to begin a consulting rim and decides to leave his current job. After his beginning(a) year in business, Cams accountant informed him that he had made $45,000 with his consulting business. Sam also notices that he paid $6,000 for a health insurance policy, which was his total benefit during his first year.What was Cams opportunity cost? Sam gave up $65,000 in salary plus $19,500 in benefits roar total of $84,500. 4. Sara Lee just graduated from college with a degree in accounting. She had five job offers Bean counters CPA, $35,000 Assets R us, $27,000 The Debit store, $30,000 J & Gs Spas, $33,000 and The Double entryway Shop, $40,000. What was her opportunity cost if she accepted the job with The Double Entry Shop? Sara gave up Bean counters CPA at $35,000 which was the highest value surrendered. 5. Sam Club earned $50,000 and paid taxes of $10,000.Samaritan Heart earned $60,000 and paid taxes of $12,000. If these taxes were paid to the same giving medication agency, is the tax on income progressive, regressive, or proportional? Why did you devolve this conclusion? As show below these taxes are proportional because they both paid the same percentage of their income in taxes. 6. You read an article in this mornings paper that stated inflation was accelerating and would reach six percent this year. If the FED believes this statement and it has set a goal of three percent inflation, what will it likely do at the next meeting of the Federal Open Market Committee?They would most likely raise the discount rate, the federal funds rate, or both. They could also sell more government securities to decrease the money supply. 7. A friend came into your office and said that his bank was out to kill downhearted businesses. You asked him what he meant by this remark, and he said that he read an article that said his bank had just loaned $10 million to a major automobile manufacturer at a rate of 3 percent, which is less than prime. But your friend ju st borrowed $50,000 from the same bank and they charged him prime plus tetrad percent, or 7. Percent. Your friend has been in business for two years, and last year he had a expiration of $2,000. How can you explain this difference in interest rate to your friend? The bank charges interest based upon risk The probability of the automobile manufacturer defaulting on the loan is very remote therefore, they get a favorable interest rate from the bank. Since your friend lost money last year and since over 40 percent of all mall businesses fail in the first five years, the banks risk is much higher and therefore they will charge a higher interest rate.