Question

Define what a relational database is. Describe its importance to an organization and why securing it is important.

Provide a database schema in tabular format and provide the necessary SQL statements to build it. Your database should include a table with a minimum of three attributes (columns). Include the SQL statement to create the table and insert data into three rows of the table.

This is an individual assignment.

Answer 1

Define what a relational database is. Describe its importance to an organization and why securing it is important.

Provide a database schema in tabular format and provide the necessary SQL statements to build it. Your database should include a table with a minimum of three attributes (columns). Include the SQL statement to create the table and insert data into three rows of the table.

This is an individual assignment.

Answer:

-- A relational database is used to store logically related data items into a relation which is nothing but a table. A table is made up of tuples, attributes, constraints, relationships, datatypes etc.

-- The importance of relational database is very important for any organization. Most of the organization use RDB for data handling, processing and storing.

-- With normalization, database redundancy and incosistency has been reduced. With relationships, multiple entities are associated. Advanced security mechanisms should be incorporated

-- to secure the information of a database. An information is an asset for any organization. The company would undergo serious financial and complaince issues if information is leaked or misused.

-- -- Your code here!

create database myDB;

use myDB;

create table Person(id integer primary key auto_increment, name varchar(30) not null, mobileNo varchar(100) not null, Age integer not null);

desc Person;

insert into Person values (null, "Jon", "123-345-444", 22);

insert into Person values (null, "Venis", "333-345-645", 34);

insert into Person values (null, "Reeta", "567-665-664", 45);

select * from Person;

id      int(11) NO      PRI     NULL    auto_increment
name    varchar(30)     NO              NULL    
mobileNo        varchar(100)    NO              NULL    
Age     int(11) NO              NULL    
1       Jon     123-345-444     22
2       Venis   333-345-645     34
3       Reeta   567-665-664     45