资料库理线上餐点订购系统课件.pptVIP

SQL – Query (9) Question 9: 全部店家的菜單,平均的價格為? Normalization of ‘Customer’ Normal forms Def. 符合 1NF Primary key= Customer_ID 每個欄位都存放單一值(atomic values) 符合2NF 同樣符合1NF格式 Non-key attributes are FD on primary key. (Customer_name, Customer_phone) 符合3NF 同樣符合2NF格式 Customer_name與Customer_phone兩者為獨立的關係 7)NormalizationED diagram ED diagram of ‘Customer’ ED diagram Customer_name Customer_phone Customer_ID Normalization of ‘Delivery receipt’ Normal forms Def. 符合 1NF Primary key= Menu_number 每個欄位都存放單一值(atomic values) 符合2NF 同樣符合1NF格式 Non-key attributes are FD on primary key. (Customer_ID, Meal_name, Meals_am