I have not been on my homepage for a long time because I am preparing for my postgraduate entrance exam. Although I have set him as my computer homepage! Too many!
There is a "Newbie" people leave a message, ask about the E-R diagram, because I am going to see the mathematics, there is not much time to explain, can only say: first, let's take a look at several entities in your system, then analyze the attributes of each object, and then link each attribute to a certain level using the contact action, is your system E-R diagram, as to conform to the third paradigm, I do not know what you want to do, not anything better to do the better of the system, after all, the connection between tables wastes much more resources than your point of redundancy. You didn't understand what you mean, and I cannot deduce it. After my postgraduate examination is over, no, I have to wait. After I finish my study in Guangzhou, will I give you an answer? I don't know which school the "Newbie" belongs to. If you are close to me, you can come to our Hebei University of Technology to find me. As I recently prepared for postgraduate entrance exams, therefore, you can contact me at 0315-2657238 or 13230577518.
Also, if I remember correctly, this should be a homework question of the 3rd! But it does not matter. I am very happy to help you, as long as your teacher has no opinion !!