On pb9.0) Demo DB V6 database, create a new table called Campaign, table structure is as follows: CampaignId (Int), the Content (10, Char activity name), Advisement activities (text, advertising), BeginDate (Date), EndDate (Date). The ID is given priority to the keyword; EndDate field effectiveness of rules set to greater than the day date,
Design the Product table and Campaign_Product table, the former is used to store goods data, including at least ProductId (primary key); The latter is used to store what goods to participate in every activity, including at least CampaignId, ProductID these two fields, enter data for the above three tables, pay attention to the foreign key constraints,
Designed a window to navigate from one date to another date to participate in the activities of all the goods list, commencement date can be input, activity title can use the drop-down box to choose, don't choose to view the product list of all activities,
CodePudding user response:
Lz is a need to know how to design the DW or implementation?CodePudding user response:
The original poster is to make our,Advice to go to see the inside of the CSDN question the wisdom of the :
http://bbs.csdn.net/IndexPage/SmartQuestion.aspx
CodePudding user response: