For the following database description a normalization diagr

For the following database description a normalization diagram.

--

A teacher wants to use a database that helps him track lessons for students. He comes to you to build his idea.

find out that he wants to give different kinds of lessons. He teaches Martial Arts as well as dancing. His martial arts classes are self defense classes or beginning Hapkido classes. His dance classes are more wide ranging including Cha Cha, Nightclub 2 Step, Triple 2, Waltz and Country 2 Step. When a student wants lessons he needs to keep their name and contact info (just phone and email) in his list. A lesson is scheduled fora date and time and a certain dance or martial art. Dance lessons cost $15 each and martial arts lessons are $20 each and he bills his students at the end of each month for any lessons they have taken.

Solution

Table 1 - Classes Class Type Class ID Martial Arts Self Defence M1 Martial Arts Hapkido M2 Dancing Cha Cha D1 Dancing Nightclub 2 step D2 Dancing Triple 2 D3 Dancing Waltz D4 Dancing Country 2 Step D5 Table 2 - Lessons Class ID (Foreign key to Classes) Date Time Table 3 - Student Student ID Name Email Phone Table 4 - Fees Type Fees Fee ID Dancing 15 1 Martial Arts 20 2 Table 5 - Bookings Class ID Student ID