Hw2-Answer

In: Computers and Technology

Submitted By kenek
Words 925
Pages 4
2.1 Define the following terms: data model, database schema, database state, internal schema, conceptual schema, external schema, data independence, DDL, DML, SDL, VDL, query language, host language, data sublanguage, database utility, catalog, client/server architecture, three-tier architecture, and n-tier architecture.
Answer:
data model: a collection of concepts that can be used to describe the structure of a database-provides the necessary means to achieve this abstraction.
database schema: The description of a database is called the database schema, which is specified during database design and is’nt expected to change frequently.
database state: The data in the database at a particular moment in time is called a database state or snapshot. It’s also called the current set of occurrences or instances in the database.
internal schema: describe the physical storage structure of the database. The internal schema uses a physical data model and describe the complete details of data storage and access paths for the database.
conceptual schema: The conceptual schema hides the details of physical storage structures and concentrates on describing entities, data types, relationships, user operations, and constraints.
external schema: Each external schema describes the part of the database that a particular user group is interested in and hides the rest of the database from that user group.
data independence: It can be defined as the capacity to change the schema at one level of a database system without having to change the schema at the next higher level.
DDL: It is used by the DBA and by database designer to define both schema.
DML: The DBMS provides a set of operations or a language called the data manipulation language for typical manipulations include retrieval, insertion, deletion, and modification of the data.
SDL: It is used to specify the internal…...

Similar Documents

Answer

... did not open the grocery, instead, he took another job, he would make 8,000 Yuan per month       (3) If he rented out his house, he could get a rent of 5,000 Yuan       (4) If he put 30,000 Yuan which will be used for the grocery, he would receive 300 Yuan interests. 1) Please explain which of the above costs is explicit and which implicit. 2) Please discuss what resources are market-supplied and what are onwer-supplied for Mr. Liu to start the grocery? 3) Calculate the total economic cost to start the grocery 1) Explicit cost is 30.000 RMB spent for food Implicit costs are all other costs, totaling 13.300. 2) Market-supplied resources is food that Mr. Liu will buy to open grocery. Owner-supplied resources are his house, his efforts to open a grocery 3) Total economic cost = explicit cost + implicit cost =30.000 + 13.300 = 43.300 3. What is the indifference curve?Please draw an indifference and answer the following questions: (1)What is the marginal rate of substitution in consumption MRSC ? (2)What is the law of diminishing marginal utility?(refer to the graph to explain) (3)If a good is subject to diminishing marginal utility how will the marginal rate of substitution in consumption MRSC change? (4)Suppose you are willing to pay 50 Yuan for an acrobatic show. But the ticket turns out be 100 Yuan。 Have you achieved your consumption optimu. Explain why. 1) Definition of the marginal rate of substitution in consumption MRSC 2...

Words: 1446 - Pages: 6

Answer

...Answering Exam Questions Many of the semester exams allow you to choose 2 or 3 questions to answer from a list. The first thing to do once you have made your choice of questions to answer is to see how much time this gives you per question – and stick to it. If you overrun badly on the first answer it means that you have less time to answer other questions well. It is also probable that you are not writing a clear answer either! Leave space to come back to it at the end if you have time and go on to the next question. For each question….. 1. Re state the question in your own words at the top. This shows the examiner your basic understanding and how you are thinking. It also helps you to frame your answer and focus your mind. 2. Write your answer plan. Choose the key words in the question and from these plan your answer. E.g. does it ask for examples, does it ask you to critically evaluate rather than discuss? What are the areas that you need to concentrate on? Use these key words and themes to form the basis of the answer plan. 3. Use your plan to write out the answer in full. Use theory and frameworks and cite references where appropriate. From an examiner’s viewpoint it is always good to see frameworks applied in context as it shows understanding. 4. Stick to the time you have allowed yourself!...

Words: 252 - Pages: 2

Comp3511 Hw2 Solution

...Fall 2011 COMP 3511 Homework Assignment #2  Handout Date: Oct. 13, 2011 Due Date: Oct. 27, 2011  Name: ______________ ID: ___________________ E-Mail: _____________ COMP 3511 L __ Please read the following instructions carefully before answering the questions:  You should finish the homework assignment individually.  There are a total of 4 questions.  When you write your answers, please try to be precise and concise.  Fill in your name, student ID, email and Section number at the top of each page. Submissions without this information will be discarded.  Please fill in your answers in the space provided, or you can type your answers in the MS Word file.  Homework Collection: the hardcopy is required and the homework is collected at the collection box (near CSE office 4205, #6 and #7). 1. (30 points) Please answer the following question briefly (1) (5 points) What are the three conditions that a solution to Critical Section problem must guarantee? Answer: A solution to the critical section problem must guarantee three conditions: mutual exclusion, progress and bounded waiting. (2) (10 points)? Scheduling criteria are often conflicting with each other. Please describe the conflict in the following two scheduling pairs: average waiting time vs. maximum waiting time, I/O device utilization vs. CPU utilization. Answer: Average waiting time and maximum waiting time: Average waiting time is minimized by executing the shortest tasks first. Such a scheduling policy...

Words: 527 - Pages: 3

Answer

... Rating Selection and Categorization Feasibility: whether applicable Creativity: whether brought up before Pertinence: whether occurs Case Studies V2, P36, 3/2 H2, P34, 3/2 Job interview Manners Clothing Voice Job ad Finding information Tricky questions Manners Facial expression Eye contact Confident/natural smile Posture Upright position Lean a little bit forward Avoid excessive gestures Sneeze/cough Say “excuse me” Cover mouth/nose with tissue/napkin/handkerchief Handshake Firmly Wait for the interviewer to extend his/her hand first Clothing Man Avoid dying hair Dark suit with matching tie Formal wear Woman Formal/professional Tri-color policy Avoid leather Voice Modest: avoid being aggressive Proactive: interested Job Ad Necessary information Small words make big difference Finding information Insider Relatives Parents Alumni The Internet Homepage BBS Blog Tricky Questions Collection Develop cracking skills Case Studies V3, P55, 2/1 H3, P88, 2/3 Summary Upon finishing this section of the course, you should be able to answer questions concerning......

Words: 2820 - Pages: 12

Hw2-Answer

...2.1 Define the following terms: data model, database schema, database state, internal schema, conceptual schema, external schema, data independence, DDL, DML, SDL, VDL, query language, host language, data sublanguage, database utility, catalog, client/server architecture, three-tier architecture, and n-tier architecture. Answer: data model: a collection of concepts that can be used to describe the structure of a database-provides the necessary means to achieve this abstraction. database schema: The description of a database is called the database schema, which is specified during database design and is’nt expected to change frequently. database state: The data in the database at a particular moment in time is called a database state or snapshot. It’s also called the current set of occurrences or instances in the database. internal schema: describe the physical storage structure of the database. The internal schema uses a physical data model and describe the complete details of data storage and access paths for the database. conceptual schema: The conceptual schema hides the details of physical storage structures and concentrates on describing entities, data types, relationships, user operations, and constraints. external schema: Each external schema describes the part of the database that a particular user group is interested in and hides the rest of the database from that user group. data independence: It can be defined as the capacity to change the schema at one...

Words: 925 - Pages: 4

Answer Key

...ANSWER KEY Comma Exercises WR, P1-1 (p 288-9) Directions: Add or delete commas where necessary in the following sentences. If a sentence is correct, write “correct” after it. a. Chinatown is generally considered to be part of the hard-boiled detective genre, but it contains many conventions that make it unlike other detective films. Correct b. As an intern, I learned about all aspects of the broadcasting industry (no comma) and trained specifically in fundraising efforts. c. J.R.R. Tolkien finished writing his draft of The Lord of the Rings trilogy in 1949, but the first book in the series wasn’t published until 1954. d. German shepherds can be gentle guide dogs, or they can be fierce attack dogs. e. Some former professional cyclists claim that performance-enhancing drug use is widespread in cycling, and they argue that no rider can be competitive without doping. 1. Reptiles are cold-blooded (no comma) and are covered with scales. 2. The low-key lighting effect known as chiaroscuro was first used in German Expressionist filmmaking (no comma) and was later seen in American film noir. 3. Freedom is an important value for many Americans, so it is a central theme in much of our political rhetoric. Correct 4. Advertisers use a variety of techniques to grab the audience’s attention and to imprint their messages into consumers’ minds. Correct 5. Many musicians of Bach’s time played several instruments, but few mastered...

Words: 1506 - Pages: 7

Model Answer

...Week 1 Conceptual Exercise: Consumer Behavior Theory 1) A decrease in the price of a particular good, with all other variables constant, causes a. a shift to a different demand schedule with higher quantities demanded b. a shift to a different demand schedule with lower quantities demanded c. a movement along a given demand curve to a lower quantity demanded d. a movement along a given demand curve to a higher quantity demanded e. no movement along a given demand curve unless supply also changes Answer: d. A movement along a given demand curve to a higher quantity demanded Explanation: According to law of demand as the price of good decreases the demand will increase. P P= Price of Good P1 Q= Quantity Demanded P2 Q Q1 Q2 As Price decrease from P1 to P2 Quantity Increases from Q1 to Q2 2) If automobiles are a normal good and the price of automobiles rises, then holding all else constant, the a. demand for automobiles will rise b. quantity demanded of automobiles will fall c. demand for automobiles will fall d. quantity demanded of automobiles will rise e. supply of automobiles will fall Answer: b. quantity demanded of automobiles will fall Explanation: Normal goods are those whose demand increases with increase in income. Now since it is given that the cost of the good rises and all other things...

Words: 1340 - Pages: 6

Mba Answer

... questions shall be of 16marks each and the last questions shall be of 20 marks. Q1 (a) “Ethics has no place in the business.” Discuss this statement (b) “An ethic of caring conflicts with morality because morality requires impartiality.” Discuss this criticism of an ethic of caring Q2 (a) “From an ethical point of view, big business is always bad business.” Discuss the pros and cons of this statement (b) “Equality, justices and a respect for rights are characteristics of the American Economic System.” Would you agree or disagree with this statement? Why? Q3 (a) Do you agree with the claims that (i) future generations have no rights, and (ii) the future generations to which we have obligations actually include only the generation that will immediately succeed us? Explain your answer. If you do not agree with these claims, state your own views and provide arguments to support them (b) Discuss the arguments for and against the 3 main theories of a producer’s duties to the customer. In your judgement, which theory is most adequate? Are there any marketing areas where one theory is more appropriate than the others? Q4 (a) In your judgement was the historical shift in emphasis from intentional/ isolated discrimination to non-intentional/ institutionalized discrimination good or bad? Justify your statement (b) Kohlberg’s views on moral development show that the more morally mature a person becomes, the more likely it is that the......

Words: 1049 - Pages: 5

Week4Short Answer

...Week Four Short Answer Janet Montminy University of Phoenix Physiological Psychology PSYCH/575 Dr. Donna Bar-Navon November 11, 2013 Week Four Short Answer Emotions can affect a person’s memory whether it is a positive emotion leading to a specific memory or a negative feeling which will lead to a terrible memory. People who take on stress in their lives or have a fearful memory, there can be an emotion which could bring out feelings which someone thought had been buried deep inside of them for many years. This writer looks at memories stored in a person’s brain in comparison to a big file cabinet where index cards are held with information. Once a memory is remembered, the index card is brought to the front of the file cabinet for remembrance. Research done at Reed College in Oregon is showing that individuals are not just feeling emotional, but are affecting the person in their functions in many different ways. A happy feeling and emotion can bring forward a happy memory from the past, but an unhappy feeling can find a person bringing a bad memory from his/her past forward. A happy memory can put someone into a happier mood, whereas a negative memory will have the reverse effect and make a person unhappy. Researchers now show a person who is bringing up a memory will also bring up the emotion they were feeling at the time no matter if the person was happy or sad, mad, fearful or stressed (Dingfelder, 2005). Depending on the emotion, a person may attach a memory...

Words: 453 - Pages: 2

Hw2 Aristarchus

...  ASTR  PTYS  206   Dr.  Kortenkamp   September  3,  2013   HW2  _  Aristarchus       The  size  of  the  Sun  compared  to  the  size  of  the  Moon  is  a  big  difference.  The   Sun  and  the  Moon  look  to  be  the  same  size,  but  it  is  deceiving  because  they  are   nowhere  close  to  being  the  same  size.  The  Sun  is  1,392,000  kilometers  across  and   the  moon  is  1,737  kilometers.  So  about  ten  moons  can  span  across  the  width  of  the   Sun.  The  Moon  and  the  Sun  are  at  two  difference  distances  from  the  Earth.  The   Moon  is  about  384,400  kilometers  from  the  Earth  and  the  Sun  is  149,600,000   kilometers  from  the  Earth.  The  Earth  is  smaller  then  the  Sun,  but  larger  then  the   Moon.       In  the  picture  below,  the  cacti  look  like  they  are  all  the  same  size.  When  you   are  standing  right  next  to  the  cacti  that  are  father  way  they  are  actually  all  different   sizes.  It  is  like  looking  at  the...

Words: 375 - Pages: 2

617 Hw2

...ECE 617 Fall 2015 Homework xizhe Mao 31344482 Use the papers/presentations: Gies, “Safety Considerations for Smart Grid Technology Equipment,” Chopra, “Remarks to IEEE International Conference on SmartGridComm,” and Budka, et.al., “GERI – Bell Labs Smart Grid Research Focus:Economic Modeling, Networking, and Security & Privacy” to answer the following. [5 points] According to Gies, in basic, high level terms, what is the smart grid? According to Gies, what is the best approach to approach the formerly separated industries of the smart grid? a. A smart grid combines the existing electrical infrastructure with digital technologies and advanced applications to provide a much more efficient, reliable and cost effective way to distribute energy. b. The best way to approach this new, merged technology is to break it down into its component technologies, then use existing or new standards to evaluate safety issues involving the component technologies. [5 points] Describe how the evolution of the power grid differs from that of the telecommunication system, from the perspective of Alexander Graham Bell and Thomas Edison being alive in the 21st century. It is said that Alexander Graham Bell would not recognize the components of modern telephony, while Thomas Edison would be totally familiar with the modern electrical grid. Thus, with smart grid, there is the potential to modernize and advance the architecture of the power systems technology in the 21st...

Words: 588 - Pages: 3

Answer

...Ch 3 Critical Thinking and Discussion Questions 1. Outline why the culture of a country might influence the costs of doing business in that country. Illustrate your answer with examples. Answer: Since in a sense the entire chapter is about this question, there can be numerous reasons and examples of how culture influences the costs of doing business. Several are highlighted in the following sentences, but there could be numerous others. When there are simply different norms between how individuals from different countries interact, the costs of doing business rise as people grapple with unfamiliar ways of doing business. For example, while in the US we may get down to business first, and then get to know each other socially later, in many South American countries it is important develop a good social relationship before trying to discuss business issues. Different class structures and social mobility also raise the costs of doing business. If there are inhibitions against working with people from different classes, then the efficiency with which information can flow may be limited and the cost of running a business increased. A country's religion can also affect the costs of business, as religious values can affect attitudes towards work, entrepreneurship, honesty, fairness, and social responsibility. In Hindu societies where the pursuit of material well-being can be viewed as making spiritual well being less likely, worker productivity may be lower than in nations...

Words: 960 - Pages: 4

Hw2 for Blaise Roncagli

... Profit (Loss) to of New Zealand Dollar Helena if Value Occurs $.51 $-.01 .52 .00 .53 .01 .54 .02 .55 .03 5-5 Compute the annualized forward discount or premium for the Mexican peso whose 90-day forward rate is $0.1050 and spot rate is $0.1200. State whether your answer is a discount or premium. = (0.105 – 0.12)/0.12 = -12.5% discount over 90 days. Annualized = -.125(360/90) = -50% annual discount 5-6 Sherwin-Williams has expects to collect a Euro-denominated receivable of €100,000 in 120 days. The current spot rate of the euro is $1.3334 and the 120 forward rate quoted today is $1.3274. Sherwin is worried that the euro will depreciate over the next 120 days, reducing the dollar value of their euro receivable. To hedge this risk, they enter into a forward contract with their bank to “sell euros forward” at the forward rate of $1.3274. Assume that 120 days later, Sherwin collects the €100,000 receivable and executes the contract. Assume also that the spot rate at that time is $1.3200. (a) How many dollars did Sherwin get for their euros by executing the contract? = (100,000*1.3274)= $132,740 in USD (b) How many dollars would Sherwin have received if they had not hedged with a forward contract but instead sold their euro receivable in the spot market? = (100,000)(1.3200) = $132,000 in USD if sold in the spot market for the current spot rate. (c) Now assume that the spot rate at the time the receivable is collected is......

Words: 1155 - Pages: 5

Answer

...Which among the 17 goals is your primary focus of interest? Ensure inclusive and equitable quality education and promote lifelong learning opportunities for all Please explain why. (Please limit your answer to 300 characters.) Although every afghan family suffers financial difficulties at some point due to the increasing rate of unemployment (which is mainly caused by lack of education and specialization) and my family was no exception regarding the issue, when compared to most of my friends and relatives, I was fortunate and privileged. My father earned enough for me to study without ever having to stop to support my family financially, but there were so many of my friends that despite being gifted, ambitious and outstanding students were in pursuit of better employment opportunities and faced financial difficulties constantly. Very often they had to give up their dreams of pursuing higher education and simply take care of their family’s needs, being the sole breadwinner in the family. I always felt their pain and could see have helpless they felt, but could not do anything to help. It is time for that to change. I hope youth assembly gives me a better sense of how I can help those who have the desire but not the means to follow their education. I believe to change the future for good, we shouldn’t focus on material realities of today but the mental realities, and by that I mean the perception and the mind-set of the current and coming generations. What would you like...

Words: 701 - Pages: 3

Assignment Answer

...1. Consider the relation CLASS(Course#, Univ_Section#, InstructorName, Semester, BuildingCode, Room#, TimePeriod, Weekdays, CreditHours). This represents classes taught in a university with unique Univ_Section#. Give what you think should be various candidate keys and write in your own words under what constraints each candidate key would be valid. Answer: Possible candidate keys include the following (Note: We assume that the values of the Semester attribute include the year; for example "Spring/94" or "Fall/93" could be values for Semester): • {Semester, BuildingCode, Room#, TimePeriod, Weekdays} if the same room cannot be used at the same time by more than one course during a particular semester. • {Univ_Section#} if it is unique across all semesters. • {InstructorName, Semester} if an instructor can teach at most one course during each semester. • If Univ_Section# is not unique, which is the case in many universities, we have to examine the rules that the university uses for section numbering. For example, if the sections of a particular course during a particular semester are numbered 1, 2, 3, ..., then a candidate key would be {Course#, Univ_Section#, Semester}. If, on the other hand, all sections (of any course) have unique numbers during a particular semester only, then the candidate key would be {Univ_Section#, Semester}. 2. Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for...

Words: 930 - Pages: 4