-
Anonymous users2024-02-06MySQL is unfamiliar, but the idea of database creation is the same:
Activity table: Stores the assignment date, assignee (associated with the primary key of the user table), and the due date of the activity.
Job file: Path, name, and job ID (associated with the primary key of the job table) can be combined into one table. There is only one entity in the workbook, and it is good to put its name and path in the worksheet;
The user table has a one-to-many relationship with the assignment table: a teacher can have multiple assignments, while an assignment can only belong to one teacher;
The same goes for the following; - The main thing is to analyze the relationship between entities and entities.
-
Anonymous users2024-02-05Both options are fine.
But if you ask me about the kind that's more plausible, I think the second one is better, and the first one records too much fragmented information.
But I'll give you some other advice.
First of all, the table needs to be divided into a fact table and a dimension table.
Teacher information, student information, and assignment information are dimensional tables that are basically code, Chinese names, and other basic information.
The specific assignment submitted is a fact sheet, which can be combined into 1 or 2 tables.
Fields such as: Assignment ID, Submission Time, Path, Name, Student ID, etc.
-
Anonymous users2024-02-04It is recommended to use it separately, and see the intermediate relationship table. Helps with other aspects of expansion.
-
Anonymous users2024-02-03Match the relationship in the table, and then use Hibernate to reverse the relationship!
-
Anonymous users2024-02-02Requirement 1 Submit the creation of the report.
Tables and SQL statements that insert table data must be tested and validated in SQL Server 2000.
2. Each student completes it independently, and if it is found that the reports of the two students are more than 25% similar, the mid-term examination scores of the two students will be recorded as 0 points, and the study committee members are requested to screen when they receive the design report.
3. The final design report should be printed on A4 paper.
4 The deadline to submit to the school committee is November 5th, and the last time to submit it to me after the school committee has been screened is November 6th.
-
Anonymous users2024-02-01Library Management Information System:
Student Form: Student ID, Name, Gender, Class, Library Card Number.
Library card form: library card number, name, book number.
Book list: book number, title, publisher, author.
-
Anonymous users2024-01-31Be careful of being cross-provincial, Haipiao-sang.
-
Anonymous users2024-01-30Tong Hai: I'm looking for it, too, haha.
The database is generally composed of many tables, for example, the school builds a database, which can build a student table (including the student's name, age, student number, class, date of birth), a teacher table (including the teacher's name, age, teaching class, teaching category), a report sheet (including the student's student number, and the grades of each subject), etc. These are the ways in which the files are stored in the database, and try to make sure that the items in a table are closely related and have the same attributes, if this condition cannot be met, a table must be built (the redundancy of the built table has 4 levels). In order to meet the user's query needs, we also need to make a number of views, for example, you can make a view of his items have the name of the student, age, grades of each subject, and the teacher of each subject, etc., we can also export new items according to the existing items, for the purpose of simplicity, for example, the view can add an average grade, we add different permissions and roles to each view, and provide it to different people to query to protect the security of the database. >>>More
There is no bottom in select
select top 1 * from table order by field 1 desc" >>>More
select ,from emp e left jion dept don ;
Left Company. The left link is, the left side prevails, and the right side is useless to make up for it. >>>More
It seems that there is something called triggers in the DB, and there seems to be another thing called transactions.
Specific software analysis.