Database/ HBASE/ SQL

Select the problem / Define the problem.
Create Tables with constraints
Design a Schema based on tables and explain the schema.
Create primary keys, foreign keys.
Create Procedures.
Create functions.
Create Views
Create Index
Use of the following Clauses:
Example : order by, between, group by, having, order by,
AND, OR, with
Use Aggregate Functions
Use of nested queries, Scalar Subquery.

Part 2 has to be done in HBASE
Create Tables – 4 tables with Column family and columns
Column family - 5 column families: Make sure have different parameter. Ex: versions
Minimum 4 Columns in each Column family
Insert records
Delete records
Perform basic queries like your assignment1
Try to extract data using timestamp
Insert partial data in a row
Describe table.
Check table status – enabled or disabled
Use count command to count the number of rows in a tables
Alter tables
…
etc.