online shopping database design

Self-taught programming, want to design and develop a shopping platform. There is only one kind of commodity, but it is divided into different types, how should this database be designed? For example, a book Book: Id:int Name:string Description:text Price:decimal Cover_image:string Books can be screened according to different criteria, for example, by category, o

Recently, I have completed a complete database design for a small project. I hope you can give me some suggestions on the design. Sometimes a project is normalProgramEmployees generally do not have access to database design. They generally have professional DBAs or old pro

Tags: status goods receipt address Lin Business Update pre = = =The following is their own in the e-commerce system design of the order module database design experience Summary, and now published to share, if inappropriate, welcome thread discussion ~ Order |--AutoNumber (order_id, self-growing primary key) |--order number (Order_no, unique value for custom

System Analysis Functional Requirements Analysis (1): Product display, according to the classification of all products, and corresponding relevant information. (2): Increase product display relevance, such as the latest product coverage, website news, promotional information. (3): Shopping cart, tracking the user's shopping situation (4): Settlement Center: Processing user billing,

type in the database to access the data in the database.2. Data Report component The data report component is mainly used for output reports. If you do not need to output reports, these components are not available. BCB has its own Quickreport, but in my opinion this report component is not very useful. In this case, you need to use a third-party report component, such as fastreport. The report

The mysql database design of the bus system, online and other existing bus lines in a certain area and their corresponding bus lines each station name, for example, 2 Che Qingshan Road -- Bayi Road -- Shanghai Road 3 Che ningnote Road -- Bayi Road -- Shanghai Road... from station name 1 to station name 2, some of them are directly connected by a shuttle bus, and

The first step is to use the "Wizard" to design a database. With the Chinese Access2000, you can organize user information from a single database file. In this file, you can separate the data in the container named "table", that is, the aforementioned "data table, then, you can use the online form to allow network user

Chinese Access2000 quick tutorial-1.1 Use the "Wizard" to design a database Chinese Access2000 quick tutorial-1.1 Use the "Wizard" to design a database First, use the Wizard to design the database. You can use Chinese Access 2

. Identify the relationship between business models (Association, dependency, combination, aggregation, generalization, implementation) 6. Converts a business model to a conceptual data model., 4, 5, 6 ErEntity and OO inDifferences between domain objects in: 1. Domain ModelA higher abstraction level, closer to the real world and business, and closer to the database 2. An object must correspond to a table, while domain ModeIt may be a virtual se

Recently in the PHP course design, ask a question about extracting the form data into the database Recently in the PHP course design, the most shopping site, I rookie, so the answer can be detailed point? Preferably with code, thank you. This interface code is this: $conn =mysql_connect (' localhost ', ' root ', ' 123

A Database design specification1 Naming conventionsAll database object names must be separated by lowercase letters and underlinedObject name prohibit use of MySQL reserved keywordNaming to be done in the name, not more than 32 bytesTemp table must have TMP prefix date suffixBackup library table bak prefix date suffixAll column names and types that store the same

1. Access method (Access Methods): This step includes storing and retrieving records from a file. 2. Alias: Another name for a property. In SQL, you can replace the table name with an alias. 3. Alternate keys (alternate key, er/relational model): There is no candidate key in the entity/table that is selected as the primary health. 4. Anomalies (exception) See update exception (updated anomalies) 5. Application design: A phase of the

The origin of a Codd RDBMS12 law--rdbmsDesign phase of two-relational databaseThree design principlesFour naming rulesDatabase design, a cornerstone of the success of a software project. Many practitioners agree that database design is not really that important. The reality of the scene is quite similar, the number of

Tags: two order distinct compute data types Char Execution plan single table milMysql Database Design specification1 database All objects are underlined in lowercase letters (because MySQL is case-sensitive)2 Disable the use of the mysql keyword3 the column name and data type of the associated column are maintained as much as possible, such as the user ID of the