|
| Hey! Please i could do with some help..
i'm(student) designing a database system(IT training institute) to hold information on client registration, course bookings, instructor/Lab allocation.
i have done all my designs(ERDs and DFDs)
But creating the course and schedule tables in access is a bit confusing as :
1, Courses are offered on beginers, int and advc levels
2, Each client can register for more than one course
3, Each course has different prices on differnt levels
The structure i have for course entity is:
Coursecode, courseTitle, CourseLevel, Price, Duration, and Discount.
The structure for Client Entity is:
ClientNO, Name,Address, Category(corporate or individual), course level, StartDate, FinishDate.
Problem is: if i'm assigning more than one course to client on the table , how would that work?
PS i have follow up questions but if i can get suggestions i'd be very thankful.Liz |
|