![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
系统设计与数据库系统
文章平均质量分 91
系统设计与数据库系统实验与心得分析
上山打老虎D
计算机本科生
展开
-
系统设计与数据库系统 大作业
Student Enrollment System1.项目简介:(意义,卖点,功能等)2.项目架构:(E-R图,模块,流程,各大功能的描述)3.项目关键设计:(关键的数据表,范式分析,以及其完成某关键功能的代码片段)(1)Front-end(2)Back-end4.项目效果图:(项目出来的效果,功能,以及其他相关图片,数据等)Project demonstration:1.项目简介:(意义,卖点,功能等)As two students who has gone through college entra原创 2021-07-09 23:40:48 · 2092 阅读 · 7 评论 -
系统设计与数据库系统 作业五 UML System Design using Microsoft Visio
Design a DFD for a Cash Dispenser (ATM Machine) with the following functions:“The Cash Dispenser system uses four processes:a. Receive-Requestb. Check-Password,c. Withdraw, andd. Show-Balance.Process Receive-Request takes a request for either wit原创 2021-07-06 00:01:07 · 317 阅读 · 1 评论 -
系统设计与数据库原理 作业四 Data Modelling using PowerDesigner
Data Modelling using Power DesignerPurpose of Experiment purpose and RequirementsCase StudyPurpose of Experiment purpose and RequirementsTransform the following ER diagram into Relations and Create the required tables using Oracle / MySQL: (with Primary原创 2021-07-05 22:37:42 · 438 阅读 · 0 评论 -
系统设计与数据库系统 作业三 Normalisation
NormalisationQuestion 1:A college keeps details about a student and the various modules the student studied. These details compriseQuestion 2: Classify the following relations as UNNORMALISED, 1NF, 2NF or 3NF. If theQuestion 3: Identify any repeating group原创 2021-07-05 22:27:50 · 545 阅读 · 0 评论 -
系统设计与数据库系统 作业二 Advanced SQL LAB
Advanced SQL command LABPurpose of Experiment purpose and RequirementsEXERCISES 2 JOINSEXERCISES 3 FUNCTIONSEXERCISES 4 DATESEXERCISES 5 GROUP BY & HAVINGEXERCISES 6 SUB QUERIES.EXERCISES 7 Data ManipulationExperiment process and contentPurpose of Ex原创 2021-07-05 22:10:02 · 3030 阅读 · 8 评论 -
系统设计与数据库系统 作业一 Basic SQL command LAB
Basic SQL command LAB1. Purpose of Experiment purpose and Requirements2. Methods and stepsFIRST: CREATE THE DATABASESECOND: CREAT THE TABLESTHIRD:INSERT VALUES INTO TABLESFORTH: USE THE COMMAND TO QUERY AND EDIT THE TABLES3. Experiment process and content原创 2021-07-05 18:19:59 · 1064 阅读 · 2 评论