Beginning Database Design- P18

Beginning Database Design- P18:This book focuses on the relational database model from a beginning perspective. The title is, therefore,Beginning Database Design. A database is a repository for data. In other words, you can store lots of informationin a database. A relational database is a special type of database using structures called tables.Tables are linked together using what are called relationships. You can build tables with relationshipsbetween those tables, not only to organize your data, but also to allow later retrieval of information fromthe database....
Nội dung trích xuất từ tài liệu:
Beginning Database Design- P18 Category_Primary primary_id primary Category_Secondary secondary_id Seller_Name primary_id (FK) seller_id (FK) Seller_Address secondary name seller_id (FK) address Category_Tertiary Buyer_Name tertiary_id buyer_id (FK) Seller Seller_Nulls secondary_id (FK) name seller_id seller_id (FK) tertiary popularity_rating Buyer return_policy join_date buyer_id Buyer_Address international popularity_rating buyer_id (FK) History join_date address Seller_Payment Methods fact_id seller_id (FK) tertiary_id (FK) payment_method Year secondary_id (FK) Region location_id (FK) year_id time_id (FK) region_id year buyer_id (FK) region seller_id (FK) history_buyer Country Time history_buyer_comment_date Quarter country_id history_buyer_comments time_id quarter_id Location history_seller year_id (FK) region_id (FK) year_id (FK) country location_id history_seller_comment_date quarter_id (FK) quarter ...