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.
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


...Course Shanghai NOS 陈文笠 (Henry) Chapter Two Basic Expressions Functions of the Language Fondness Of course, I sure love … Oh, yeah, … is always my favorite. Well, … is a bit too …, but I sure love the … of …. Well, some say that … is a bit too …, but I sure love the … of …. Disfavor No, not at all / absolutely not/ definitely not. I’d rather not. Well, generally speaking, … is fine with me, but I’m not so keen on the … of …. To tell the truth, … To be honest, … Preference I’d much prefer … I’d rather … I enjoy … much more than … Reasoning Well, there are many reasons to this, but the most important one is that … Lengthening the Answers Well, there are many …, but … is always my favorite. Well, it depends. Hesitation Hmm/Er/Well/… Exemplification For example For instance Say Take … as an example Such as Absolute Comparison …, which is definitely/absolutely/by far/by all means/undoubtedly/probably the most … I’ve ever … Prediction It is quite likely that … … will probably … Asking for Repetition I’m sorry, but I didn’t quite catch the meaning/sentence/question. I beg your pardon. Would you please repeat the question? Sorry, what was that? Asking for Explanation I’m afraid I don’t quite understand. I’m sorry, but I am not quite sure what you meant by......

Words: 2820 - Pages: 12


...[pic] CORPORATE LAW (100 Marks) SECTION-A Q.1 Answer the following questions:(Any five) (40 Marks) 1. 'Corporate planning may be viewed as an organizational process that results in the development of the organization’s purposes, missions, objectives, goals, strategies, policies and detailed action plans to achieve the objectives.'Explain the statement. What benefits would ensure to an organization using corporate planning? 2. What would be your role and functions if you were the CEO of a business organization operating in an environment of intense competition? 3. Distinguish between the Opportunity and Threat matrices. 4. Explain Shell's Directional Policy Matrix. 5. What do you understand by Break even analysis? Explain the concept with the help of an example. 6. Briefly explain 'Product Life Cycle Approach'. 7. What are the usual motives for mergers and acquisitions? What factor would make mergers and acquisitions successful? Give relevant examples. Answer the following: (Any four) (20 Marks) 1. 'Strategy includes the determination and evaluation of alternative paths to an already established mission or objective and eventually, choice of the alternatives to be adopted.' Explain the statement underlining the process......

Words: 1055 - Pages: 5


...in assessing your pi'ogiess in th'q lludi of illis e Lit,! rr "Galolt': Before atternpting the assignnisr'li reot-l lhe dirccti':irs glven (l) ln this assignment twc kinds olil:lestiors hai,e i:een askeci. 'l'he iirst k-ind of qriesliorl will test your comprehension of the maleri:-,ls ples*nted i;t the units. Tne seionci. k-ind question kinC will test your ai:iiity tl cre,:iivcly apply ttrein in reai lil* situati:i.. Ine aim of this ccurse is to enabtre y*u ic use tiii: F,iigiisti lenguage in re:*l iiie srtu-atitns. o E#ectively and creative ly. lviost of- tiie q*estrons are of the seeond kirrii, as ibey wlil help you to u.se Engiish" (2) While writing the assignmenf keei:r rire purir.v of"vcr.r ianguage and readabriif;v cf'ycur answer in mind Keep the following tn rnind rvhile preparing the draft f,or subrnisslote" 1. Read the detailed instnictions on assigncrr:nts Bivefl in the Pr*gramttr€ iluide f:, the Electi"re {-ouses. 2. Wr.ite your the first l1aine. elroirnent nuinlier. iLlll aridr,:ss ai-.o.ri iia.te an lhe iop rrght i'trndx i)i] pagr.i 3i:-,,/o,1r a-i.15\4'ei sileet{si. 3. Write the Claurse Titie, Assignlsetlr |ll:;:ii:e: ,tnd tne li"iai'vie of rne -qrturtr5' 'dttached to in ihe centre oithe fir3t page of v,-lLti rssnonse sh*et{si' ilecre ',''1-r 3ro iioi-i, \i{} blAl"{!:.: ".. AD}RESS COURSE TITLFI: ... ASSIGNEMNT NC S'X'L]DY CE'TiTII, 5,: . I-! *.'4,;' 'l-Use only facl:rcan ltize patr;cl' il:r......

Words: 750 - Pages: 3


...System.Web.Creation Points Earned: 1.0/1.0 Correct Answer(s): B 2. An IP address is: A) an internet protocol address B) a set of numbers distinguishing computers C) a value that identifies a server D) All of the above Points Earned: 1.0/1.0 Correct Answer(s): D 3. Web Form files have the extension: A) .wasp B) .wbfm C) .aspx D) .aspc Points Earned: 1.0/1.0 Correct Answer(s): C 4. Microsoft's _________ technology is used for web-based application development. A) ASP .NET B) APM .NET C) PHP .NET D) All of the above Points Earned: 1.0/1.0 Correct Answer(s): A 5. The information tier typically stores data in a(n) ___________. A) DataGrid B) XML document C) relational database management system D) None of the above Points Earned: 1.0/1.0 Correct Answer(s): C 6. When a Web Form object is ready for garbage collection, the _________ event occurs. A) GCollect B) GC C) Unload D) Dispose Points Earned: 1.0/1.0 Correct Answer(s): C 7. _________ C#, ASP.NET is ____________. A) Unlike, case sensitive B) Like, case sensitive C) Unlike, not case sensitive D) Like, not case sensitive Points Earned: 1.0/1.0 Correct Answer(s): C 8. The code-behind file is a(n) _______ class. A) full B) virtual C) partial D) abstract Points Earned: 1.0/1.0 Correct Answer(s): C 9. _________ applications divide functionality into separate logical. A) Internet B) Multi-tier C) Logical D) None of the above Points Earned: 1.0/1.0 Correct Answer(s): B 10. The asp: tag prefix means that:......

Words: 27152 - Pages: 109


...Dear students, These are answers and guidance to the homework, and I hope that it will be useful to you. If you have any problems or there is something wrong with the answers, you can contact me by Email. hanjijiayou@gmail.com. Yours, HanJi Uniervsity of International Business and Economics IMBAProgram Managerial Economics Problem set #1 March 12, 2011 1. Suppose Carl and John lived on an island. Initially, there were unaware of each other. So each was forced to be self-sufficient. Carl found that it took him 1 hour to pick a kilogram of fruits or catch one fish. John found that it took him 1.5 hours to pick a kilogram of fruits or 3 hours to catch one fish. The productivities of the two individuals are shown in the table below. Labor requirements for fruits and fish |Labor required for: | | |1 kilogram of fruits |1 fish | |Carl |1 hour |1 hour | |John |1.5 hours |3 hours | 1) What is the absolute advantage in production. Who has the absolute advantage of producing both goods, Carl or John? Define the absolute advantage,as we can see from the......

Words: 1446 - Pages: 6

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

Model Answer

...Model Answers HW2 - Chapter #3 1. The hypothetical machine of figure 3.4 also has two I/O instructions: 0011= Load AC fro I/O 0111= Store AC to I/O In these cases the 12-bit address identifies a particular I/O device. Show the program execution (using format of figure 3.5) for the following program: 1. Load AC from device 5. 2. Add contents of memory location 940. 3. Store AC to device 6. Assume that the next value received from device 5 is 3 and that location 940 contains value of 2. Answer: Memory 300 3005 301 5940 302 7006 . . 940 0002 941 We will assume that the memory (contents in hex) as the previous table: 300: 3005; 301: 5940; 302: 7006 Therefore, the steps will be as the following: Step 1: 3005 → IR Step 2: 3 → AC Step 3: 5940 → IR Step 4: 3 + 2 = 5 → AC Step 5: 7006 → IR Step 6: AC → Device 6 ------------------------------------------------------------------------------------------------------2. Consider a hypothetical 32-bit microprocessor having 32-bit instructions composed of two fields: the first byte contains the opcode and the remainder the immediate operand or an operand address. a. What is the maximum directly addressable memory capacity (in bytes)? b. Discuss the impact on the system speed if the microprocessor bus has 1. a 32-bit local address bus and a 16-bit local data bus, or 2. a 16-bit local address bus and a 16-bit local data bus. c. How many bits are needed for the program counter and the instruction register? Answer: a. 2^(32-8) = 2^24 =......

Words: 3034 - Pages: 13


...Answer 1. It means that IT need to provide security for its data and it can’t be changed by anyone that does not belong and that same person can’t view it as well, and the data will be there when need by the CEO or whoever needs it. And if anything that is changed or moved it will be reported to management as soon as possible. 2. Richard Scrushy is the owner and founder of HealthSouth Corp he was the first CEO charged with violating the Sarbanes-Oxley act. 3. CEO and CFO of company 4. 10K is for reporting annual results and 10Q is for reporting quarterly results and it would be the CEO or CFO 5. Companies with a public float of $700 million or more and the deadline will be 40 days. 6. It would be in the SEC Edgar Database 7. Microsoft - Frank H. Brod; Nike - Mark G. Parker; Cisco - John T. Chambers 8. In section 1519 violators will be fined and imprisoned for no more than 20 years, 1520 section A (a) of the securities Exchange Act of the 1934 (the “34 Act”) to maintain all audit or review work papers for a period of 5 years from the end of the fiscal period in which the audit or review was conclude. 9. It was the J-SOX compliance Management Software Solution and Services based on Council of the Japanese Financial Services Agency provided final Implementation 10. Convicted of looting more than $600 million from their company, both were convicted of grand larceny. 11. Researchers have noted that information security in implicit in the requirements of SOX , and......

Words: 362 - Pages: 2


...function which ensures “jobs to be filled with the right people, with the right knowledge, skill & attitude” is comes under__________ a. Staffing defined b. Job analysis c. Manpower planning d. Recruitment 10. It is a process that enables a person to sort out issues and reach to a decisions affecting their life: a. Selection b. Raining c. Reward d. Counseling Part Two:1. What do you understand by Maslow‟s Theory of Motivation? 2. Define Management By Objective. 3. Differentiate between co- ordination and co-operation. 4. Write a short note on „Acceptance theory‟. END OF SECTION A Section B: Caselets (40 marks)      This section consists of Caselets.  Answer all the questions.  Each Caselet carries 20 marks.  Detailed information should form the part of your answer (Word limit 150-200 words). 2 IIBM of Business Management Examination Paper of Principles and Practices of Management Caselet 1 Mr. Vincent, the Manager of a large supermarket, was taking a management course in the evening programme at the local college. The Professor had given an interesting but disturbing lecture the previous night on the various approaches to management. Vincent had always thought that management involved just planning, organizing and controlling. Now this Professor was saying that management could also be thought of as quantitative models, systems theory and analysis, and even something called contingency relationships. Vincent had always......

Words: 1350 - Pages: 6

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


...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

...HW2 Assignment FIN465 – Chapters 4,5 Instructor: Dr. Blaise Roncagli You may use your book and notes when working on these problems, and you may work in groups with others, but the final product that you submit for grading must be your own work. Follow the instructions provided in this handout very carefully. Failure to follow instructions may result in loss of points. Chapter 4 Problems 4.1 Assume the spot rate of the British pound is $1.6610. The expected spot rate one year from now is assumed to be $1.5500. What percentage change does this reflect? Does the pound appreciate or depreciate? Change in %: (1.5500 – 1.6610) / 1.6610 * (100) = -6.68%. The pound will depreciate because one pound can buy less USD if the future spot rate is accurate. 4.2 Gigantic Bank expects that the Singapore dollar will depreciate against the dollar from its spot rate of $.46 to $.44 in 90 days. The following interbank lending and borrowing rates exist: (Note: these are annual rates, not 90 day rates.) Lending Rate Borrowing Rate U.S. dollar 8.0% 8.3% Singapore dollar 23.0% 25.5% Gigantic Bank considers borrowing 10 million Singapore dollars in the interbank market and investing the funds in dollars for 90 days. Estimate the profits (or losses) that could be earned from this strategy. Should Gigantic Bank pursue this strategy? 1.) SGD 10,000,000*.46 =......

Words: 1155 - Pages: 5


...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

...______________ 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 could however starve long-running tasks and thereby increase their waiting time. I/O device utilization and......

Words: 527 - Pages: 3

The Answers

...The Answers When presented with the question “What is religion?” my argument can go several different ways. I have my own opinion of religion based off my upbringing and how I was raised to think about it, but at the same time this course allowed me to see a different perspective of religion and what it does for people. The official definition of religion is “The belief in and reverence for a supernatural power or powers, regarded as creating and governing the universe”. The first thing that comes to mind when thinking about religion is the following of one or more Gods to seek guidance in life. People feel like they need to follow something or someone and that is known meaning for religion. In my opinion that following is the act of religion, the meaning and purpose of religion is different. After examining the the material throughout this semester I have concluded that religion is a structure that was put in place millions of years ago to provide guidance and an explanation for some of the things we will never know. We do not know how or why we ended up on this Earth, so people use religion as an explanation for that. It's comforting knowing that there is a God or Gods that put us here for a certain reason, and that is what religion gives us.There a lot of things in this world that are unexplained and we will never actually know why or how they happened, so people use religion and mystical experiences to try and become enlightened. The different beliefs and practices in......

Words: 1537 - Pages: 7