Right now I am working on a small project, since the company does not have a DBA so I have to take some data model design work, thanks in advance for any comments and advice.
1. Business requirement--Course registration and management
.Couse management should like this
Internet------>HTLM------> Session 1(offering)
------->Session 2
------->3
-------->4
------>XML -------->Session 1
--------> Session 2
and more I creat table like this:
CourseCatalogue--->Course----->Offering
I just seperate course to 3 tables, does it make sense or just creat a big table.
Thans again
1. Business requirement--Course registration and management
.Couse management should like this
Internet------>HTLM------> Session 1(offering)
------->Session 2
------->3
-------->4
------>XML -------->Session 1
--------> Session 2
and more I creat table like this:
CourseCatalogue--->Course----->Offering
I just seperate course to 3 tables, does it make sense or just creat a big table.
Thans again