codemummy
82 FOLLOWERS
codemummy is a coding site. This site helps computer science students to gain knowledge and prepare for the interview!!
codemummy
3y ago
Structured Query Language (SQL) helps users to communicate with the database.
SQL lets you access, manipulate and managing data in a relational database management system (RDBMS).
SQL is domain specific language .
SQL is declaration language (what should be done is only thing to be told, how to do is not required).
SQL commands:
1)DDL: data definition language ,it works on structure of the table/relation.
2)DML: Data manipulation language ,once the table is created ,to store ,manage, access, delete data in the table DML is used.
3)DCL: Each and every user will have t ..read more
codemummy
3y ago
Data Abstraction
Data Abstraction refers to the process of hiding unwanted/unnecessary data from the user.
for example if we are using social apps like whatsapp we can send and receive messages but we don't know how data is stored, where data is stored ,which data structure is used, all this information is not given to user.
There are three levels of data abstraction and to achieve data independence we divide data abstraction in three levels. Data Independence means there should be no direct interaction between user and data.
View Level
Conceptual Level
Physical Level ..read more
codemummy
3y ago
Lesson 2 Wrap Up
These solutions are for reference only.
It is recommended that you should solve the assignment and quiz by yourself honestly then only it makes sense to complete the course.
but if you cant figure out some part of it than you can refer these solutions
make sure you understand the solution
dont just copy paste it
-----------------------------------------
main course : https://www.coursera.org/learn/matlab ..read more
codemummy
3y ago
Echo Generator
These solutions are for reference only.
It is recommended that you should solve the assignment and quiz by yourself honestly then only it makes sense to complete the course.
but if you cant figure out some part of it than you can refer these solutions
make sure you understand the solution
dont just copy paste it
-----------------------------------------
echo_gen.m
function output = echo_gen(in,fs,delay,gain)
samples = round(fs * delay) ;
ds = floor(samples);
signal = zeros(length(in) + ds, 1);
signal(1:length(in)) = in;
echo_signal = zeros(length(in) + ds, 1);
ech ..read more
codemummy
3y ago
Saddle Points
These solutions are for reference only.
It is recommended that you should solve the assignment and quiz by yourself honestly then only it makes sense to complete the course.
but if you cant figure out some part of it than you can refer these solutions
make sure you understand the solution
dont just copy paste it
-----------------------------------------
blur.m
function [output] = blur(A, w)
[rows, columns] = size(A);
B = nan(size(A) + 2 * w);
B(w + 1 : end - w, w + 1 : end - w) = A;
output = 0 * A;
for i = w + 1 : rows + w
for j = w + 1 : columns + w
tmp = B(i - w ..read more
codemummy
3y ago
Saddle Points
These solutions are for reference only.
It is recommended that you should solve the assignment and quiz by yourself honestly then only it makes sense to complete the course.
but if you cant figure out some part of it than you can refer these solutions
make sure you understand the solution
dont just copy paste it
-----------------------------------------
saddle.m
function indices = saddle(M)
indices = zeros(0, 2);
[rows, columns] = size(M);
for row = 1:rows
for column = 1 : columns
point = M(row, column);
if isGreaterThan(point, M(row, :)) && isSmallerThan(p ..read more
codemummy
3y ago
Text Files
These solutions are for reference only.
It is recommended that you should solve the assignment and quiz by yourself honestly then only it makes sense to complete the course.
but if you cant figure out some part of it than you can refer these solutions
make sure you understand the solution
dont just copy paste it
-----------------------------------------
char_counter.m
function charnum = char_counter(file_name, character)
file = fopen(file_name, 'rt');
if file < 0 || ~ischar(character)
charnum = -1;
return;
end
charnum = 0;
line = fgets(file);
while ischar(line)
ch ..read more
codemummy
3y ago
Excel Files
These solutions are for reference only.
It is recommended that you should solve the assignment and quiz by yourself honestly then only it makes sense to complete the course.
but if you cant figure out some part of it than you can refer these solutions
make sure you understand the solution
dont just copy paste it
-----------------------------------------
get_distance.m
function distance = get_distance(x,y)
persistent raw;
if isempty(raw)
[~, ~, raw] = xlsread('Distances.xlsx');
end
state1_index = state2index(raw, x);
state2_index = state2index(raw, y);
if state ..read more
codemummy
3y ago
Using Cell Arrays
These solutions are for reference only.
It is recommended that you should solve the assignment and quiz by yourself honestly then only it makes sense to complete the course.
but if you cant figure out some part of it than you can refer these solutions
make sure you understand the solution
dont just copy paste it
-----------------------------------------
sparse2matrix.m
function matrix = sparse2matrix(sparse_matrix)
dimensions = cell2mat(sparse_matrix(1));
n = dimensions(1); m = dimensions(2);
default = cell2mat(sparse_matrix(2));
matrix = default * ones(n, m ..read more
codemummy
3y ago
Character Vectors
These solutions are for reference only.
It is recommended that you should solve the assignment and quiz by yourself honestly then only it makes sense to complete the course.
but if you cant figure out some part of it than you can refer these solutions
make sure you understand the solution
dont just copy paste it
-----------------------------------------
caesar.m
function coded = caesar(sequence, shift)
sequence = double(sequence);
sequence = sequence + shift;
coded = char(loop(32, 126, sequence));
end
function val = loop(start, stop, val)
r = stop - start + 1 ..read more