我如何创建数据库 [英] How I Creat Data Base
问题描述
我想创建一个电子学习的ACCESS数据库，包括两个班级和一些学生以及4个测试，并找出任何测试学生喜欢的数据挖掘
< blockquote>首先，您需要考虑将要使用数据库的内容，以及可能会使用该数据库的人。
我想要什么样的信息/必须存储？
我想从数据库中获取什么样的信息/报告？
然后你需要创建一个数据库结构。为此，您可以从回答以下问题开始：
我应该拥有哪些表格？ （哪个数据属于哪个表）
表之间有什么关系？
我会要求数据库生成报告的查询是什么？
傻瓜相关数据库 [ ^ ]
绝对初学者数据库设计指南 [ ^ ]
到目前为止，您可以使用笔和纸来创建结构。它实际上并不依赖于您选择的数据库。
作为初学者，了解数据库规范化也是一件好事。通过遵循良好的数据库设计规则，您将在开始时花费大量时间，但肯定会花费更多时间。
请参阅数据库规范化中的1NF，2NF，3NF和BCNF [ ^ ]
要在Access中专门创建数据库，可以使用以下链接：
创建Access数据库 - 访问 [ ^ ]
如何使用MS Access创建数据库（带图片） [ ^ ]
你注意到我没有告诉你有关你的设计的任何细节。
其中一个原因是它不清楚你想做什么。
我认为你可以排序通过阅读我提供的链接来了解它。
祝你好运
I want to create an ACCESS database of e-learning includes two class and a number of students and 4 tests and find out any test students liked by data mining
To begin with you need to think about what you are going to use the database for, and maybe who will use it.
What kind of information do I want/have to store?
What kind of information/reports do I want to get from the database?
Then you need to create a database structure. In order to do that you can start with answering the questions below:
What tables should I have? (What data belongs in which table)
What are the relations between the tables?
What are the queries I will ask the database to generate the reports?
Relational Databases for Dummies[^]
Absolute Beginner's Guide to Database Design[^]
So far you can use pen and paper to create your structure. It is not really dependent on your choice of database.
As a beginner it is also good to know about database normalization. By following the rules for a good database design, you will spend a lot of time in the beginning, for sure, but much less time later on.
See 1NF, 2NF, 3NF and BCNF in Database Normalization[^]
To create your database specifically in Access, you can use the following links:
Create an Access database - Access[^]
How to Make a Database Using MS Access (with Pictures)[^]
As you have noticed I haven't told you any specifics about your design.
One reason for this is that it is not exactly clear what you want to do.
I think that you will be able to sort it out by reading the links I have provided.
Good luck
这篇关于我如何创建数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
