Given Information: A direct mapped cache design with a 32-bit address is given. The following table shows the bits of addresses which are used to address the cache. Tag Index Offset 31-10 9-5 4-0

Question

You have database for EDMDB that contains two table as describing below: tbUser: create table tbUser (UserID int primary key auto_increment, UserName varchar(100) not null, password varchar(20), level int default 3, regDate date); UserID(P.K.) UserName 1 Ali 2 Sara 3 Jasim Password Level 1234 1 regDate 1-10-2018 1234 2 1-11-2018 1234 1 15-11-2018 Q1-Create TbDoc as describe above. Q2: insert the data in to the table as a variable data? Q3: delete user who name is Jasim. Q4: update to change each values of Password from 1234 to 4321? Q5: delete each record from tbUser when Level is 2? Good Luck!

Answer 1

Question

Chapter 5, Problem 5.3.6E

Program Plan Intro

Given Information:

A direct mapped cache design with a 32-bit address is given. The following table shows the bits of addresses which are used to address the cache.

Tag Index Offset
31-10 9-5 4-0

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

You have database for EDMDB that contains two table as describing below: tbUser: create table tbUser (UserID int primary key auto_increment, UserName varchar(100) not null, password varchar(20), level int default 3, regDate date); UserID(P.K.) UserName 1 Ali 2 Sara 3 Jasim Password Level 1234 1 regDate 1-10-2018 1234 2 1-11-2018 1234 1 15-11-2018 Q1-Create TbDoc as describe above. Q2: insert the data in to the table as a variable data? Q3: delete user who name is Jasim. Q4: update to change each values of Password from 1234 to 4321? Q5: delete each record from tbUser when Level is 2? Good Luck!

محولة من جُومَانَا ) Design and draw a circuit using a decoder to select four memory devices 27256 starting at memory location 40000H and three memory devices 62256 starting at memory location A0000H. Hint: additional information needed you will find in the datasheet. ممكن الحل 4:57 ✓

Information Technology department You have database EDMS DB contains the documents table as describing below: CREATE TABLE doc_tb (doc_id int PRIMARY KEY AUTO_INCREMENT, doc_no int,doc_date date, title varchar(100), direction int, person varchar(100), notes varchar(100)); direction doc_id 1 doc_no 234 doc_no 2022-5-1 Title Add serves 4 2 5484 3 36 2022-5-9 2022-5-14 Move employ to Basra Thanks for all employee 12 person Ali Hameed Sara Hasan Notes 1 Null Q1: insert all the data above using parameter. Q2: Update the table by adding notes word '#' for each person have words 'Ha'. Q3: Update the table by adding notes word '*' when the document not refereeing for any person. 4: delete each record from the table when the value of notes contains '*'; Good Luck!