- first part
- principle in database system
- main content of each lecture notes
- can you remember data vs information vs knowledge and wisdom (big picture)
- principle in database system
ไม่ใช่ Multiple Choice น่าจะให้เขียนตอบ
-
second parts
- formulate business rule requirement (write statements ) lecture 3-5
- many to many
- forward + backward
-
third part
- diagram design
- chain notation
- draw ER diagram (100%) - element ต่าง ๆ
- how to design multi-value, composite attribute, weak entity (ทุกคนพัง) (weak entity must depend on strong entity)
- ไปทำความเข้าใจแบบอาจารย์ให้ดี เพราะน่าจะเล่นเรื่องนี้เลยล่ะ
-
fourth part
- transform ER diagram to relational diagram
- make sure to understand exercise
-
4-5 main questions
-
20 minutes for each question
-
reserve 1 hour to draw ER diagram
-
How to get a bonus
- draw a complete notation
- additional idea, write your own business rule (note in the business exam)
- DO NOT have the conflict idea, with the exam content.
-
And a spoil from my friend
โอ้วว เค้าไม่มีแจกแต่ของเนื้อหามิดเทอมยู ของเราเค้าจะมี business rules มาให้ แบบ
“• The Jonesburgh County Basketball Conference (JCBC) is an amateur basketball
association.
• Each city in the county has one team as its representative.
• Each team has a maximum of 12 players and a minimum of 9 players.
• Each team also has up to three coaches (offensive, defensive, and physical training
coaches).
• During the season, each team plays two games (home and visitor) against each of the
other teams. Note that each player and coach must belong to the team.”
แล้วเค้าก็ให้ทำ ER diagram แล้ว transforms เป็น Relational database
composite attribute, inherit the key
what about composite attribute and multivalue at the same time