Sparse Matrix: A matrix is a two-dimensional data object made of m rows and n columns, therefore having total m × n values and a matrix which contains very few non-zero elements is called sparse matrix. They usually lack the spatial locality in the data stream found in matrix operations. Example of a sparse matrix: M = ( 0 0 0 0 5 8 0 0 0 0 3 0 0 6 0 0 ) Here, “M” is a “ 4 × 4 ” sparse matrix as most of the elements are “0”. Yale Sparse Matrix Format: The Yale Sparse Matrix Format or the Compressed Sparse Row (CSR) is used to represent a sparse matrix by three arrays that contains non zero values. The Yale Sparse Matrix format stores a sparse m × n matrix M in row representation using three one-dimensional arrays known as (A, IA, JA) and “NNZ” is used to denote the number of nonzero entries in matrix “M”. “R” is used to represent the number of non-zero entries.

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 6, Problem 6.18.4E

Program Plan Intro

Sparse Matrix:

A matrix is a two-dimensional data object made of m rows and n columns, therefore having total m × n values and a matrix which contains very few non-zero elements is called sparse matrix.

They usually lack the spatial locality in the data stream found in matrix operations.

Example of a sparse matrix:

M= (0 0 0 05 8 0 00 0 3 00 6 0 0)

Here, “M” is a “4 × 4” sparse matrix as most of the elements are “0”.

Yale Sparse Matrix Format:

The Yale Sparse Matrix Format or the Compressed Sparse Row (CSR) is used to represent a sparse matrix by three arrays that contains non zero values.

The Yale Sparse Matrix format stores a sparse m × n matrix M in row representation using three one-dimensional arrays known as (A, IA, JA) and “NNZ” is used to denote the number of nonzero entries in matrix “M”.

“R” is used to represent the number of non-zero entries.

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!