...(20) Explain how generalization can be implemented in a relational data model. Ans: Select common properties from different class, create one superclass and add in superclass. (21) Explain why HDD devices are slower than SSD devices. Ans: HDD devices are slower than SSD devices as HDD has moving parts which have potential quality drop issue in long term and take longer time to store data due to the disk inside is spinning and mechanical arm need to write data on the disk. While SSD do not have any moving parts. Furthermore, Solid State Drive uses non-volatile memory made from NAND based silicon wafer and data will not be lost on SSD if power lost. (22) Explain how relational tables are mapped into files. Logical storage files have data segments, each data segment stores relational table and each index segment stores index. (23) Explain a difference between manual space management and automatic space management. Ans: Manual segment space management uses linked lists known as free lists to manage free space in the segment. Automatic space management uses bitmap to manage free space in segments and it is more efficient then manual segment space management. (24) Explain a concept of "role" and provide an example different from the examples included in lecture slides where application of "role" is really useful. Ans: Role is a kind of permission which decide which user can perform certain action or remove action like create or update to a database. For example, grant admin...
Words: 892 - Pages: 4
...process state specifies in which state the process isie., new, ready, running or waiting • Program counter: It address the next instruction should be executed. • CPU registers: general purpose registers, flag register, stack pointer, indexed registers etc,. • Memory Allocations: It maintains the information about the memory allocated to the process. The Context Switching is the mechanism to stop executing of one process (let it be p1) and start the execution of another process (let it be p2). The PCB maintains all the information of process p1 to restart the execution after completion of p2. Q8: what are the five processes states defied by the textbook? Between which two of these states does the process scheduler move a process? Why? 1. New : the process born will be in this state 2. Ready: The process in new state moves into the queue known as ready state which ready to execute this state schedule the process for execution. 3. Running : The process in the ready queue ready state or waiting queue in waiting state is moved to execute is nothing but running state. 4. Waiting : waiting state is used hold the process which are requires resources during execution and schedules after resources aquired. 5. Terminated : After completion of execution process will be moved to this state Ready and running are the two scheduling states to move the process to running state depending on resource allocation or order of service. Q9: Explain how UNIX fork () and exec () system calls...
Words: 1498 - Pages: 6
...TABLE 1 Information Items in CCD Header and Sections in the CCD Body CDA area Data things TABLE 2 Segments in the Korean Standard for CDA Referral and Reply Letters Body (Preliminary Version) CDA CDA CDA Header Document Information (creation time, Segments in CDA body Referral Answer format ID, dialect code, object) Patient's data (ID, name, sexual orientation, birth date) Creator's data (ID, name, spoke to association) Organization's data (name, address, telephone number) CDA Body Payers Propel Directives Bolster Utilitarian Status Issues Family History Social History Allergies Medications Medical Equipment Vital Signs Comes about Procedures Encounters Plan of Care For the incorporated CDA record, we picked the Korean Standard for CDA Referral and Reply Letters (Preliminary Version) design as the quantity of clinical archives created when patients are alluded and answers made, is vast . It has the indistinguishable structure as the CCD and the sorts of information contained in the body are recorded in Table 2. Distributed computing Distributed computing alludes to both the applications conveyed as administrations over the...
Words: 838 - Pages: 4
...have one domain controller (not recommended), there is nothing to do since all roles must be on this server, but if you have multiple servers you should move some of theese roles on to more servers. It is also important to be aware of what servers are Global Catalog servers, especially if you have more than one domain and even if only one domain, they will be prefered by applications like Exchange server. It is recommended to place the forest roles on one Domain Controller (DC) and the domain roles on another server. If not all Domain Controllers are Global Catalog servers, it is also important to place the infrastructure master on a server that is NOT a Global Catalog server. Recommended Best Practice setup of FSMO roles. Domain Controller #1 Place the two forest roles on this server. * Schema Master * Domain Master Domain Controller #2 Place the domain roles on this server. * RID Master * Infrastructure Master * PDC Emulator If more domains exist in the forest, place the domain roles on a server in theese domains like Domain Controller #2 Global Catalog configuration. In Windows 2008 Active Directory all Domain Controllers are by default Global Catalog servers, personally...
Words: 10360 - Pages: 42
...practices, various media and interconnection components), networking devices and their specifications and functions. Students will practice designing physical network solutions based on appropriate capacity planning and implementing various installation, testing and troubleshooting techniques for a computer network. Where Does This Course Belong? | | | NT2799 | | | | | | | | NSA Capstone | | | | | | | Project | | | | | NT2580 | | | NT2670 | NT2640 | | PT2520 | | Introduction to | | | | | | | | | | | Email and Web | | | | | Information | | | | IP Networking | | Database Concepts | | | | | Services | | | | | Security | | | | | | | | | | | | | | | | NT1330 | | | NT1230 | NT1430 | | PT1420 | | Client-Server | | | Client-Server | | | Introduction to |...
Words: 10839 - Pages: 44