A survey on the spare time life of level 05 information major students in a university's School of Information can be selected or customized (1) Design the following data items and data structures.
1. Question information, including data items: number, topic, and number of votes.
2. Option information, including data items: number, option number, option content, and number of votes.
(2) Database conceptual structure design. Based on the entities planned above. (3) Logical design. Basic table design. Convert ER diagram into relational schema. Using the characteristics of relational databases, the system is designed as a database containing two basic tables:
1. Main table: number, topic, number of votes.
2. Attached table: number, option number, option content, number of votes.
Under DB is the Sql database file. After appending, modify the database connection information under App_Code.
Expand
