52 Pages

L14Mem1

Course: CS 324, Fall 2008
School: Mt. Holyoke
Rating:
 
 
 
 
 

Word Count: 2416

Document Preview

Computer CS324: Architecture CS324: The Memory Hierarchy: Caches Memory Hierarchy Memory Storage in computer systems: Processor holds data in register file (~100 Bytes) Registers accessed on nanosecond timescale Memory (well call main memory) More capacity than registers (~Gbytes) Access time ~50-100 ns Hundreds of clock cycles per memory access?! Disk HUGE capacity (virtually limitless) VERY slow: runs...

Register Now

Unformatted Document Excerpt

Coursehero >> Massachusetts >> Mt. Holyoke >> CS 324

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
Computer CS324: Architecture CS324: The Memory Hierarchy: Caches Memory Hierarchy Memory Storage in computer systems: Processor holds data in register file (~100 Bytes) Registers accessed on nanosecond timescale Memory (well call main memory) More capacity than registers (~Gbytes) Access time ~50-100 ns Hundreds of clock cycles per memory access?! Disk HUGE capacity (virtually limitless) VERY slow: runs ~milliseconds Motivation: Why We Use Caches (written $) Motivation: 1000 Performance 100 10 1 1981 1983 1984 1985 1986 1987 1982 1988 1980 CPU Proc 60%/yr. Processor-Memory Performance Gap: (grows 50% / year) DRAM DRAM 7%/yr. 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 1989 first Intel CPU with cache on chip 1989 1998 Pentium III has two levels of cache on chip 1998 Memory Caching Memory Mismatch between processor and memory speeds leads Mismatch us to add a new level: a memory cache Implemented with same IC processing technology as the Implemented CPU (usually integrated on same chip): faster but more expensive than DRAM memory. Cache is a copy of a subset of main memory. Cache Most processors have separate caches for instructions Most and data. Memory Memory Hierarchy Higher Levels in memory hierarchy Lower Processor Increasing Distance from Proc., Decreasing speed Level 1 Level 2 Level 3 ... Level n Size of memory at each level As we move to deeper levels the latency goes up and price per bit goes down. Memory Hierarchy Memory If level closer to Processor, it is: If smaller faster subset of lower levels (contains most recently used data) Lowest Level (usually disk) contains all available Lowest data (or does it go beyond the disk?) Memory Hierarchy presents the processor with the Memory illusion of a very large, very fast memory. How is the hierarchy managed? How Registers <-> Memory Registers by compiler (programmer?) cache <-> memory cache by the hardware memory <-> disks memory by the hardware and operating system (virtual memory) by the programmer (files) Memory Hierarchy Analogy: Library Memory Youre writing a term paper at a table in the Dwight Library is equivalent to disk essentially limitless capacity very slow to retrieve a book Table is main memory smaller capacity: means you must return book when table fills up easier and faster to find a book there once youve already retrieved it Memory Hierarchy Analogy: Library Memory Open books on table are cache smaller capacity: can have very few open books fit on table; again, when table fills up, you must close a book much, much faster to retrieve data Illusion created: whole library open on the tabletop Keep as many recently used books open on table as possible since likely to use again Also keep as many books on table as possible, since faster than going to stacks Why hierarchy works Why The Principle of Locality: The Program access a relatively small portion of the address space at any instant of time. Probability of reference 0 Address Space 2^n - 1 Memory Hierarchy Basis Memory Cache contains copies of data in memory that are being used. Memory contains copies of data on disk that are being used. Caches work on the principles of temporal and spatial locality. Temporal Locality: if we use it now, chances are well want to use it again soon. Spatial Locality: if we use a piece of memory, chances are well use the neighboring pieces soon. Memory Hierarchy: Terminology Hit: data appears in some block in the upper level (ex: Block X) Hit Rate: the fraction of memory access found in the upper level Hit Time: Time to access the upper level which consists of RAM access time + Time to determine hit/miss Miss: data needs to be retrieve from block in a lower level (Block Y) Miss Rate = 1 - (Hit Rate) Miss Penalty: Time to replace a block in the upper level + Time to deliver the block the processor Hit Time << Miss Penalty Upper Level To Processor Memory Blk X Why? Lower Level Memory Blk Y From Processor Memory Hierarchy of a Modern Computer System Processor Control Second Level Cache (SRAM) Main Memory (DRAM) Secondary Storage (Disk) Tertiary Storage (Disk) On-Chip Cache Registers Datapath Speed (ns): 1s Size (bytes): 100s 10s Ks 100s Ms 10,000,000s 10,000,000,000s (10s sec) (10s ms) Ts Gs By taking advantage of the principle of locality: By Present the user with as much memory as is available in the cheapest technology. Provide access at the speed offered by the fastest technology. Cache Design Cache How do we organize cache? How Where does each memory address map to? Where (Remember that cache is subset of memory, so multiple memory addresses map to the same cache location.) How do we know which elements are in cache? How How do we quickly locate them? How Direct Mapped Cache There is exactly one location to which a block can be There moved Mapping: address is modulo the number of blocks in the Mapping: cache Cache 000 001 010 011 100 101 110 111 01101 10001 00001 00101 01001 10101 11001 11101 Memory Direct-Mapped Cache Direct Each memory address maps to only one block in the cache Each Block is the unit of transfer between cache and memory We only need look in a single location in the cache for the data if it exists in the cache Mapping: address is modulo the number of blocks in the cache Mapping: Cache 000 001 010 011 100 101 110 111 00001 00101 01001 01101 10001 10101 11001 11101 Memory Direct-Mapped Cache Direct Memory Address Memory 0 1 2 3 4 5 6 7 8 9 A B C D E F Cache Index 0 1 2 3 4 Byte Direct Mapped Cache Cache Location 0 can be occupied by Cache data from: Memory location 0, 4, 8, ... In general: any memory location that is multiple of 4 Issues with Direct-Mapped Issues Since multiple memory addresses map to same cache Since index, how do we tell which one is in there? What if we have a block size > 1 byte? What Result: divide memory address into three fields Result: ttttttttttttttttt iiiiiiiiii oooo tag to check if have correct block index to select block byte offset within block (given possible blocks for this location) (of cache) Direct-Mapped Cache Direct Terminology All fields are read as unsigned integers. All Index: specifies the cache index (which row of the Index cache we should look in) Offset: once weve found correct block, specifies Offset which byte within the block we want Tag: the remaining bits after offset and index are Tag determined; these are used to distinguish between all the memory addresses that map to the same location Direct-Mapped Cache Example Direct Suppose we have a 16KB direct-mapped cache with Suppose 4 word blocks. Determine the size of the tag, index and offset fields Determine if were using a 32-bit architecture. Offset Offset need to specify correct byte within a block block contains 4 words 16 bytes 24 bytes need 4 bits to specify correct byte Direct-Mapped Cache Example Direct Index Index need to specify correct row in cache cache contains 16 KB = 214 bytes block contains 24 bytes (4 words) # rows/cache = # blocks/cache (since theres one block/row) = bytes/cache bytes/row = 214 bytes/cache 24 bytes/row = 210 rows/cache need 10 bits to specify this many rows Direct-Mapped Cache Example Direct Tag Tag used remaining bits as tag tag length = mem addr length - offset - index = 32 - 4 - 10 bits = 18 bits so tag is leftmost 18 bits of memory address Accessing data in a direct mapped cache Accessing Example: 16KB, directExample: mapped, 4 word blocks Read 4 addresses Read Memory Address (hex) Value of Word ... ... a 00000010 b 00000014 c 0x00000014, 0x0000001C, 00000018 d 0000001C 0x00000034, 0x00008014 ... ... Memory values on right: Memory e 00000030 only cache/memory level of 00000034 f hierarchy g 00000038 h 0000003C ... ... i 00008010 j 00008014 k 00008018 l 0000801C ... ... Accessing data in a direct mapped cache Accessing 4 Addresses: Addresses: 0x00000014, 0x0000001C, 0x00000034, 0x00008014 4 divided Addresses (for convenience) into Tag, Addresses Index, Byte Offset fields 000000000000000000 000000000000000000 000000000000000000 000000000000000010 Tag 0000000001 0100 0000000001 1100 0000000011 0100 0000000001 0100 Index Offset Accessing data in a direct mapped Accessing cache So lets go through accessing some data in this cache So 16KB, direct-mapped, 4 word blocks Will see 3 types of events: Will cache miss: nothing in cache in appropriate block, so fetch cache from memory cache hit: cache block is valid and contains proper address, cache so read desired word cache miss, block replacement: wrong data is in cache at cache appropriate block, so discard it and fetch desired data from memory 16 KB Direct Mapped Cache, 16B blocks Valid bit: determines whether anything is stored in that row Valid (when computer initially turned on, all entries are invalid) Valid Index Tag 00 10 20 30 40 50 60 70 ... 0x0-3 0x4-7 0x8-b Example Block 0xc-f ... 1022 0 1023 0 Read 0x00000014 = 000 0..001 0100 000000000000000000 0000000001 0100 000000000000000000 Tag field Valid Index Tag 0 10 20 30 40 50 60 70 ... 0 Index field Offset 0x4-7 0x8-b 0xc-f 0x0-3 ... 1022 1023 0 0 So we read block 1 (0000000001) So 000000000000000000 0000000001 0100 000000000000000000 Tag field Valid Index0 Tag 00 10 20 30 40 50 60 7 0 1022 0 Index field Offset 0x4-7 0x8-b 0xc-f 0x0-3 ... ... 1023 No valid data No 000000000000000000 0000000001 0100 000000000000000000 Valid Index Tag 00 10 20 30 40 50 60 70 ... Tag field 0x0-3 0x4-7 Index field Offset 0x8-b 0xc-f ... 1022 0 1023 0 So load that data into cache, setting tag, valid So 000000000000000000 0000000001 0100 000000000000000000 Valid Index Tag 00 11 0 20 30 40 50 60 70 ... Tag field 0x0-3 a Index field Offset 0x4-7 b 0x8-b c 0xc-f d ... 1022 0 1023 0 Read from cache at offset, return word b Read 000000000000000000 0000000001 0100 000000000000000000 Valid Index Tag 00 11 0 20 30 40 50 60 70 ... Tag field 0x0-3 a Index field 0x4-7 b Offset 0x8-b 0xc-f c d ... 1022 0 1023 0 Read 0x0000001C = 000 0..001 1100 Read 000000000000000000 0000000001 1100 000000000000000000 Valid Index Tag 00 11 0 20 30 40 50 60 70 ... Tag field 0x0-3 a Index field Offset 0x4-7 b 0x8-b c 0xc-f d ... 1022 0 1023 0 Data valid, tag OK, so read offset return word d Data 000000000000000000 0000000001 1100 000000000000000000 Valid Index Tag 00 11 0 20 30 40 50 60 70 ... 0x0-3 a 0x4-7 b 0x8-b c 0xc-f d ... 1022 0 1023 0 Read 0x00000034 = 000 0..011 0100 Read 000000000000000000 0000000011 0100 000000000000000000 Tag field Valid 0x0-3 Index Tag 00 a 11 0 20 30 40 50 60 70 ... ... Index field Offset 0x4-7 0x8-b 0xc-f b c d 1022 0 1023 0 So read block 3 So 000000000000000000 0000000011 0100 000000000000000000 Tag field Valid Index Tag 0 01 0 10 20 30 40 50 60 7 ... Index field Offset 0x4-7 b 0x0-3 a 0x8-b c 0xc-f d ... 1022 0 1023 0 No valid data No 000000000000000000 0000000011 0100 000000000000000000 Tag field Valid 0x0-3 Index Tag 00 a 11 0 20 30 40 50 60 70 ... ... Index field Offset 0x4-7 0x8-b 0xc-f b c d 1022 0 1023 0 Load that cache block, return word f Load 000000000000000000 0000000011 0100 000000000000000000 Tag field Valid 0x0-3 Index Tag 00 a 11 0 20 e 31 0 40 50 60 70 ... ... Index field Offset 0x8-b 0xc-f 0x4-7 b f c g d h 1022 0 1023 0 Read 0x00008014 = 010 0..001 0100 Read 000000000000000010 0000000001 0100 000000000000000010 Valid Index Tag 00 11 0 20 31 0 40 50 60 70 ... Tag field 0x0-3 a e Index field Offset 0x4-7 0x8-b 0xc-f b f c g d h ... 1022 0 1023 0 So read Cache Block 1, Data is Valid So 000000000000000010 0000000001 0100 000000000000000010 Tag field Valid Index 0 Tag 0 0 10 21 0 30 40 50 60 7 0 1022 0 Index field Offset 0x4-7 b f 0x0-3 a e 0x8-b c g 0xc-f d h ... ... 1023 Cache Block 1 Tag does not match (0 != 2) Cache 000000000000000010 0000000001 0100 000000000000000010 Tag field Valid 0x0-3 Index Tag 00 a 11 0 20 e 31 0 40 50 60 70 ... ... Index field Offset 0x4-7 0x8-b 0xc-f b f c g d h 1022 0 1023 0 Miss, so replace block 1 with new data & tag Miss, 000000000000000010 0000000001 0100 000000000000000010 Tag field Valid 0x0-3 Index Tag 00 i 11 2 20 e 31 0 40 50 60 70 ... ... Index field Offset 0x4-7 0x8-b 0xc-f j f k g l h 1022 0 1023 0 And return word j And 000000000000000010 0000000001 0100 000000000000000010 Tag field Valid Index Tag 0x0-3 00 i 112 20 e 310 40 50 60 70 ... ... Index field Offset 0x4-7 j f 0x8-b k g 0xc-f l h 1022 0 10230 Direct Mapped Cache A d d r e s s ( s h o w i n g b it p o s i t io n s ) 31 30 13 12 11 210 Byte offset Hit 20 Tag Index 10 Data For MIPS: For Index Valid Tag 0 1 2 Data 1021 1022 1023 20 32 What kind of locality are we taking advantage of? Direct Mapped Cache Taking advantage of spatial locality: Taking Address (showing bit positions) 31 16 15 16 Tag Index 16 bits V Tag 128 bits Data 4 32 1 0 12 2 Byte offset Block offset Hit Data 4K entries 16 32 32 32 32 Mux 32 Hits vs. Misses Read hits Read this is what we want! Read misses Read stall the CPU, fetch block from memory, deliver to cache, restart Write hits: Write can replace data in cache and memory (write-through) write the data only into the cache (write-back the cache later) Write misses: Write read the entire block into the cache, then write the word Handling Cache Misses Handling Data: Data: stall CPU & freeze all register contents Wait until data arrives (write data to cache) restart instruction at cycle that caused the miss Instructions: Instructions: Send PC-4 to the memory wait for memory to complete read write the data into the cache restart instruction at first step, this time finding it in the cache Block Size Tradeoff Block Benefits of Larger Block Size Benefits Spatial Locality: if we access a given word, were likely to access other nearby words soon (Another Big Idea) Very applicable with Stored-Program Concept: if we execute a given instruction, its likely that well execute the next few as well Works nicely in sequential array accesses too But, miss rate NOT the only cache performance But, metric Block Size Tradeoff Block Drawbacks of Larger Block Size Drawbacks Larger block size means larger miss penalty on a miss, takes longer time to load a new block from next level on If block size is too big relative to cache size, then there are too few blocks Result: miss rate goes up Result: In general, minimize In Average Access Time = Hit Time x Hit Rate + Miss Penalty x Miss Rate Block Size Tradeoff Block Hit Time = time to find and retrieve data from Hit current level cache Miss Penalty = average time to retrieve data on a Miss current level miss (includes the possibility of misses on successive levels) Hit Rate = % of requests that are found in current Hit level cache Miss Rate = 1 - Hit Rate Miss Extreme Example: One Big Block Extreme Valid Bit Tag Cache Data B3 B2 B1 B0 Cache Size = 4 bytes Block Size = 4 bytes Cache Only ONE entry in the cache! If item accessed, likely accessed again soon If But unlikely will be accessed again immediately! The next access will likely be a miss The Continually loading data into the cache but discard data (force out) before use it again Nightmare for cache designer: Ping Pong Effect Block Size Tradeoff Conclusions Block Miss Penalty Miss Rate Exploits Spatial Locality Fewer blocks: compromises temporal locality Block Size Average Access Time Block Size Increased Miss Penalty & Miss Rate Block Size Things to Remember Things We would like to have the capacity of disk at the We speed of the processor: unfortunately this is not feasible. So we create a memory hierarchy: So each successively lower level contains most used data from next higher level exploits temporal locality and spatial locality do the common case fast, worry less about the exceptions (design principle of MIPS) Locality of reference is a Big Idea Locality
Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

Mt. Holyoke - CS - 324
CS324: Computer Architecture CS324:The Memory Hierarchy: Caches IIDirect Mapped CacheMapping: address is modulo Mapping: the number of blocks in the cacheHitCache 000 001 010 011 100 101 110 111Address (showing bit positions) 31 30 13 12 11 210Byte
Mt. Holyoke - CS - 324
CS324: Computer Architecture CS324:Lecture 16: Virtual MemoryAnalyzing Multi-level cache hierarchy AnalyzingDRAMCPI =1; 0.25ns clockProcL1 hit time$L2 hit time$2400 cycle Miss Penalty to main memoryL2 Miss Rate L2 Miss PenaltyL1 Miss Rate L1 M
Mt. Holyoke - CS - 324
CS324: Computer Architecture CS324: Computer ArchitectureLecture 20: Busses &amp; I/OMotivation Motivation for Input/OutputI/O is how humans interact with computers I/O gives computers long-term memory. gives computers long memory I/O lets computers do ama
Mt. Holyoke - CS - 324
CS324: Computer Architecture CS324: Computer ArchitectureLecture 18: Multicores &amp; MultiprocessorsImproving Improving PerformancePipelining Instruction Level Parallelism (ILP) Out-of-order (uses register renaming) Deeper pipeline: more stages -&gt; more i
UCSB - FEMST - 20
Karla Lopez Women Studies 150 Professor Leila Rupp, Tracy Royce M5pm 20 April 20, 2009 Pop Culture Paper My pop culture paper will focus on reality love shows such as Flavor of Love, For the Love of Ray J, Bret Michaels Love Bus, I Love New York, and A Sh
Stanford - CS - CS106A
Mehran Sahami CS 106AHandout #10 September 28, 2009Section Handout #1Karel the RobotBased on a handout by Eric RobertsThis week in section, your first priority is to meet your section leader and discover what sections in CS 106A are all about. Your se
Stanford - CS - CS106A
Mehran Sahami CS 106AHandout #25 October 19, 2009Strings ExamplesBased on examples by Eric Roberts and Patrick Young.Checking for palindromespublic boolean isPalindrome(String str) cfw_ for(int i = 0; i &lt; str.length() / 2; i+) cfw_ if (str.charAt(i)
Stanford - CS - CS106A
Mehran Sahami CS 106AHandout #38 November 9, 2009Section Handout #7: Using Interactors and the DebuggerBased on a handout by Eric Roberts1. Using Interactors The purpose of this problem is to give you some practice using the kind of interactors you ne
Stanford - CS - CS106A
Mehran Sahami CS 106AHandout #38A November 11, 2009Solution to Section #7Based on a handout by Eric Roberts1. Using Interactors/ File: BoxDiagram.java / This program allows the user to create a set of boxes with labels / and then drag them around in
Stanford - CS - CS106A
Mehran Sahami CS 106AHandout #39 November 11, 2009Assignment #6NameSurfer Due: 3:15pm on Friday, November 20thThe NameSurfer assignment was created by Nick Parlante and further revised by Patrick Young and Eric RobertsThis assignment has two primary g
Stanford - CS - CS106A
Mehran Sahami CS 106AHandout #40 November 11, 2009MusicShop Program (ComponentListener Example)File: MusicShop.java/* * File: MusicShop.java * -* This program handles the data management for a music * shop, showing which albums are carried and how man
Stanford - CS - CS106A
Mehran Sahami CS 106AHandout #41 November 16, 2009Section Handout #8: Data StructuresParts of this handout by Brandon Burr and Patrick YoungYour task for this section is to write a program that reads in a file containing flight destinations from vario
Stanford - CS - CS106A
Mehran Sahami CS 106AHandout #42 November 16, 2009FlyTunes Program (Data Structures Example)File: Song.java/* * File: Song.java * -* Keeps track of the information for one song * in the music shop, including its name, the band * that it is by, and its
Stanford - CS - CS106A
Mehran Sahami CS 106AHandout #43 November 18, 2009Packaging Your Program into a Distributable JAR FileBased on a handout by Eric Roberts and Brandon BurrNow that youve written all these wonderful programs, wouldnt it be great if you could package them
Stanford - CS - CS106A
Mehran Sahami CS 106AHandout #44 November 20, 2009Assignment #7FacePamphlet Due: 3:15pm on Friday, December 4th(Electronic submission only hardcopies of program not required) Note: No late days (free or otherwise) may be used on Assignment #7For many
Stanford - CS - CS106A
Mehran Sahami CS 106AHandout #45 November 30, 2009Section Handout #9: Objects and Data structuresParts of this handout by Eric Roberts and Patrick Young1. Primitive vs. Objects Let's say a student writes the following line of code in a predicate metho
Stanford - CS - CS106A
Mehran Sahami CS106AHandout #46 December 2, 2009Practice Final ExaminationFinal Exam Time: Thursday, December 10th, 12:15pm-3:15pm (Please note: there is no alternate Final Exam time available) Final Exam Location: Last name starting with A-J: Cubberle
Stanford - CS - CS106A
Mehran Sahami CS106AHandout #47 December 2, 2009Solutions to Practice Final ExamPortions of this handout by Eric RobertsProblem 1: Short answer (15 points) Answer for 1a: When an object is passed into method, a reference to the object (i.e., its addre
École Normale Supérieure - AA - 123456
Name: _ Class: _ Date: _ID: AExam #1 Test BankMultiple Choice Identify the letter of the choice that best completes the statement or answers the question. _ 1. What do economists mean when they state that a good is scarce? a. There is a shortage or ins
Charles Sturt University - MIT - ITC 594
1. Executive summary.2 2. Case.3 3. Introduction4 4. Issue identified4-5 5. Analysis 5.1. Planning Security.5 5.2. Contingency planning.6 6. Information Security Policy and program policy .6-7 7. Program.7-8 8. Assessing risk.8 9. Controlling risk9 10. Me
Charles Sturt University - MIT - ITC 594
TABLE OF CONTENTSSTUDENT ASSESSMENT/ASSIGNMENT COVER SHEET.ERROR! BOOKMARK NOT DEFINED. STUDENT ASSESSMENT/ASSIGNMENT RECEIPT .ERROR! BOOKMARK NOT DEFINED. TABLE OF CONTENTS . 1 EXECUTIVE SUMMARY . 2 ISSUED IDENTIFIED. 2 ANALYSIS. 3 PLANNING . 3 POLICY A
Charles Sturt University - MIT - ITC 594
TABLE OF CONTENTS:INTRODUCTION: .2 EXECUTIVE SUMMARY: .2 ISSUE IDENTIFIED: .3 ANALYSIS: .4 PLANNING .4 SECURITY PLANNING: .4 CONTINGENCIES PLANNING: .
Charles Sturt University - MIT - itc254
For ITC412 it will be in 3 parts as for ITC211, but a slightly different (more demanding) breakup: 1. PART A 25 Multiple Choice Questions 2. PART B 10 Short Answer Questions out of 123. PART C - Case Study You are required to model the below case stud
Charles Sturt University - MIT - itc254
Systems Analysis - Tutorial Week 1True/False 1. Systems analysis and design focuses on understanding the business problem and outlining the approach to solve it. 2. When choosing between possible solutions to a business problem, the best solution is the
Charles Sturt University - MIT - itc254
Systems Analysis - Tutorial Week 1 - SolutionTRUE/FALSE 1. 2. 3. 4. 5. ANS: ANS: ANS: ANS: ANS: T T T T T PTS: PTS: PTS: PTS: PTS: 1 1 1 1 1 REF: REF: REF: REF: REF: 5 6 12 13 6MULTIPLE CHOICE 6. ANS: 7. ANS: 8. ANS: 9. ANS: 10. ANS: COMPLETION 11. 12.
Charles Sturt University - MIT - itc254
Systems Analysis - Tutorial Week 2True/False 1. The support phase includes maintaining and enhancing the system. 2. The first activity in the project planning phase is to develop the project schedule. 3. The initial definition and scope of the business p
Charles Sturt University - MIT - itc254
Systems Analysis - Tutorial Week 2 - SolutionTUTORIAL SOLUTIONS TRUE/FALSE 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. ANS: ANS: ANS: ANS: ANS: ANS: ANS: ANS: ANS: ANS: T F F F T T F T T F REF: 46 REF: 38 REF: 38 REF: 46 REF: 46 REF: 45 REF: 36 REF: 45 REF: 61 REF: 5
Charles Sturt University - MIT - itc254
Systems Analysis - Tutorial Week 31. List and explain the activities of the project planning phase. 2. List the seven reasons why projects fail.3. List the five reasons why projects are successful. 4. What are three reasons projects are initiated?5. De
Charles Sturt University - MIT - itc254
Systems Analysis - Tutorial Week 3- SolutionNOTE: All page numbers referred are from the textbook, Satzinger, J, Jackson, R.B. &amp; Burd, S.D. (2007). Systems analysis and design in a changing world, (5th ed.). Boston, Massachusetts: Course Technology. 1. L
Charles Sturt University - MIT - itc254
Systems Analysis - Tutorial Week 4NOTE: All page numbers referred are from the textbook, Satzinger, J, Jackson, R.B. &amp; Burd, S.D. (2007). Systems analysis and design in a changing world, (5th ed.). Boston, Massachusetts: Course Technology. 1. 2. 3. 4. 5.
Charles Sturt University - MIT - itc254
Systems Analysis - Tutorial Week 4- SolutionNOTE: All page numbers referred are from the textbook, Satzinger, J, Jackson, R.B. &amp; Burd, S.D. (2007). Systems analysis and design in a changing world, (5th ed.). Boston, Massachusetts: Course Technology. 1. W
Charles Sturt University - MIT - itc254
Systems Analysis - Tutorial Week 5 &amp; 6- SolutionNOTE: All page numbers referred are from the textbook, Satzinger, J, Jackson, R.B. &amp; Burd, S.D. (2007). Systems analysis and design in a changing world, (5th ed.). Boston, Massachusetts: Course Technology.
Charles Sturt University - MIT - itc254
Systems Analysis - Tutorial Week 5 &amp; 6- Solution NOTE: All page numbers referred are from the textbook, Satzinger, J, Jackson, R.B. &amp; Burd, S.D. (2007). Systems analysis and design in a changing world, (5th ed.). Boston, Massachusetts: Course Technology.
Charles Sturt University - MIT - itc254
Systems Analysis - Tutorial Week 7- SolutionNOTE: All page numbers referred are from the textbook, Satzinger, J, Jackson, R.B. &amp; Burd, S.D. (2007). Systems analysis and design in a changing world, (5th ed.). Boston, Massachusetts: Course Technology.Revi
Charles Sturt University - MIT - itc254
Systems Analysis - Tutorial Week 8, Week 9NOTE: All page numbers referred are from the textbook, Satzinger, J, Jackson, R.B. &amp; Burd, S.D. (2007). Systems analysis and design in a changing world, (5th ed.). Boston, Massachusetts: Course Technology.Review
Charles Sturt University - MIT - itc254
Systems Analysis and Design in a Changing World, Fifth Edition11Learning ObjectivesExplain the key role of a systems analyst in business Describe the various types of systems an analyst might work on Explain the importance of technical, people, and bu
Charles Sturt University - MIT - 424
Study Centre SydneyINTERNAL SUBJECT OUTLINE 2008-70ITC114 &amp; ITC423 Database Systems ManagementSubject LecturerAntoinette Cevenini Email: a.cevenini@sga.edu.auLectureFriday 8:30am-12:30pm Lab: 53TutorialsThe weekly instruction in this subject will
Charles Sturt University - MIT - 424
ScenarioCountry doctorProduce an ERD and RDM corresponding to the following problem description. The doctor in a small country town describes the situation, as it will be after the new computer system is in use . Patients make appointments, these are re
Charles Sturt University - MIT - 424
From: &lt;Saved by Windows Internet Explorer 7&gt; Subject: The Relational Data Model, Normalisation and effective Database Design Date: Fri, 29 Feb 2008 11:55:18 +1100 MIME-Version: 1.0 Content-Type: text/html; charset=&quot;utf-8&quot; Content-Transfer-Encoding: quoted
Charles Sturt University - MIT - 424
Solution ERD:ERD Conceptual Level1STUDENTn 1receiveshas1COMPANY1 1nnPLACEMENTn nattends receiveshasEMPLOYMENThasmn mattendsEVENTmnREPRESENTATIVE1involved innattendsnSTAFF1involved innCONTACTn nhashas11CONTACT_SUBJEC
Charles Sturt University - MIT - 424
DB Modelling Question: Business Description The School of Accounting &amp; Computer Science at Charles Sturt University (CSU) offers a Bachelor of Computer Science (Games Technology). A key aspect of this course is the industrial placement component which stu
Charles Sturt University - MIT - 424
Final Exam Guide Part A: 2 Questions (40 marks - 20 marks each) - Database Design Part B: 8 Questions (20 Marks - 2.5 marks each) - SQL Queries Part C: 4 Questions (20 marks - 5 marks each) - Short Answer Questions Part D: 20 Multiple choice questions (20
Charles Sturt University - MIT - 424
Normalisation questions.1. To keep track of office furniture, computers, printers, and so on, the FOUNDIT company uses the table structure shown in the below table: Attribute Name ITEM_ID ITEM_LABEL ROOM_NUMBER BLDG_CODE BLDG_NAME BLDG_MANAGERa) b)Samp
Charles Sturt University - MIT - 424
ITC114/423 Practice ExamTime given: 2 hoursStudent Name: _ ID: _Short Answer Questions:1.Explain multi-valued attributes, and provide an example. How are multivalued attributes indicated in the Chen model? How are they indicated in the Crows Foot mod
Charles Sturt University - MIT - 424
Review Answers: from Chapters 7 &amp; 8
Charles Sturt University - MIT - 424
1. Explainmultivaluedattributes,andprovideanexample.Howaremultivalued attributesindicatedintheChenmodel?HowaretheyindicatedintheCrows Footmodel?2. Whatisaweakrelationship?Provideanexample.3. Whatstepsareinvolvedintheconversiontothirdnormalform?4. Expla
Charles Sturt University - MIT - 424
Section 3 Test - Solutions3.1 List the name of each event type, and the number of times that event is recorded as having been on.T2Q 3.1 SELECT event_name, COUNT(*) AS number_of_events_with_this_name FROM event GROUP BY event_name; event_name number_of_
Charles Sturt University - MIT - 424
Practical Workbook 2Using SQLHatherly, D., Witney, N. (1999). Revised Blackmore, K. (2005)Using SQL V2iUsing SQLTable of ContentsUsing Microsoft Access.1 Opening a database.1 Entering new SQL SELECT statements.1 Displaying or running saved SQL SELE
Charles Sturt University - MIT - ITC 594
Study Centre SydneyINTERNAL SUBJECT OUTLINE 2009-40ITC482 - Computer Management and Security Subject Outline Faculty of BusinessSubject LecturerPhillip KanzanisEmail: phillip_kazanis@yahoo.com.au Lecture Monday 5-9pm Lab 53TutorialsThe weekly instr
Charles Sturt University - MIT - ITC 594
ITC482 Computer Management &amp; SecurityLecturer Phillip Kazanis1 Review of Subject Outline Lecture Material - CSU Interact Timetable (make up classes) Assignment submission - TurnItIn Exam style Lecture 12 Management of Information Security, 2nd ed. -
Charles Sturt University - MIT - ITC 594
http:/interact.csu.edu.au/access/content/group/ITC482_200940_S_I/Tutorial/week01.htmhttp:/interact.csu.edu.au/access/content/group/ITC482_200940_S_I/Tutorial/week02.htmhttp:/interact.csu.edu.au/access/content/group/ITC482_200940_S_I/Tutorial/week03.htm
Charles Sturt University - MIT - ITC 594
ITC482 Computer Management &amp; Security Tutorial Week 01 _ _ITC482 Computer Management &amp; Security Tutorial Week 01 Week 01 Introduction to the Management of Information Security Review Questions 1. A globally interconnected commercial world has emerged fro
Charles Sturt University - MIT - ITC 594
ITC482 Computer Management &amp; Security Tutorial Week 01 - Solutions _ _ITC482 Computer Management &amp; Security Tutorial Week 01 - Solutions Week 01 Introduction to the Management of Information Security Review Questions 1. A globally interconnected commerci
Charles Sturt University - MIT - ITC 594
ITC482 Computer Management &amp; Security Tutorial Week 02 - Solutions _ _ITC482 Computer Management &amp; Security Tutorial Week 02 - Solutions Week 02 Planning for Security Review Questions 1. What are the three common layers of planning? How do they differ? 2
Charles Sturt University - MIT - ITC 594
ITC482 Computer Management &amp; Security Tutorial Week 02 - Solutions _ _ITC482 Computer Management &amp; Security Tutorial Week 02 - Solutions Week 02 Planning for Security Review Questions 1. What are the three common layers of planning? How do they differ?A
Charles Sturt University - MIT - ITC 594
ITC482 Computer Management &amp; SecurityTutorial Week 03 - SolutionsITC482 Computer Management &amp; Security Tutorial Week 03 - Solutions Week 03 Planning for Contingencies Review Questions 1. What is the name for the broad process of planning for the unexpec
Charles Sturt University - MIT - ITC 594
ITC482 Computer Management &amp; SecurityTutorial Week 03 - SolutionsITC482 Computer Management &amp; Security Tutorial Week 03 - Solutions Week 03 Planning for Contingencies Review Questions 1. What is the name for the broad process of planning for the unexpec
Charles Sturt University - MIT - ITC 594
ITC482 Computer Management &amp; SecurityTutorial Week 04ITC482 Computer Management &amp; Security Tutorial Week 04 Week 04 Information Security Policy Review Questions 1. What is information security policy? Why it is critical to the success of the information
Charles Sturt University - MIT - ITC 594
ITC482 Computer Management &amp; SecurityTutorial Week 04 - SolutionsITC482 Computer Management &amp; Security Tutorial Week 04 - Solutions Week 04 Information Security Policy Review Questions 1. What is information security policy? Why it is critical to the su
Charles Sturt University - MIT - ITC 594
ITC482 Computer Management &amp; SecurityTutorial Week 05ITC482 Computer Management &amp; Security Tutorial Week 05 Week 05: Developing the Security Program Review Questions 1. What is an information security program? 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14.
Charles Sturt University - MIT - ITC 594
ITC482 Computer Management &amp; SecurityTutorial Week 05 - SolutionsITC482 Computer Management &amp; Security Tutorial Week 05 - Solutions Week 05: Developing the Security Program Review Questions 1. What is an information security program?Answer: An informat