About HBase schema design

[SingoWong <si...@gmail.com>]

Hi,

I begin HBase schema design, but now i face some confused.

In RDBMS, my design is 3 tables:
*

Courses

id

pk

name

type


Students

id

pk

curses_id

fk => Courses.id

name

gender

age
*
*
*

In HBase, i think my design is

*row***

*Column families*

*Info:***

*Student_name:***

*Student_gender:*

<course_id>

Info:name

Student_name:<student_id>

Student_gender:<student_id>

Info:type



Is it my design correct?
but if design like this, when i want to find how many students under one
course, i dont know how to filter.
if i design as two table in hbase, is it normalization?

Thanks & Regards,
Singo