22C4400 – Database Systems
本篇文章向大家介绍《22C4400 – Database Systems》,主要包括MySQL,具有一定的参考价值,需要的朋友可以参考一下。
22C4400 – Database Systems Project – Initial 1/28/2019
Project Scope
Raman Aravamudhan RSA-22C4400-S19-PROJECT-SCOPE
Department of Computer Science Page 1 of 5 Version 1.1
Note: This document is intentionally incomplete and is in non-standard
format; as part of the course details on requirements will be provided when
asked.
Project Scope:
A new airline company “Iowa Air” has come to Iowa with Cedar Rapids as
its Headquarters. Iowa Air seeks to build their Airline Passenger
Reservation System (ARS). This airline is expected to attract Iowa and
surrounding passengers in a big way. The Reservation system must be
simple, easy to use and offer very high performance.
Customer seeks to build a state of the web application for their Airline.
Students can take www.aa.com for example for detailed functionality.
Project will follow an open book approach which means extensive
discussions with TA and myself are permitted.
In Phase1, Iowa Air plans to operate only Nonstop flights to 5 cities in the
United States; passengers should be able to pay using Visa/Master Card,
and thereafter be able to query the system about their reservation. The
airline schedules can be altered at any time and must be easy to change.
Details of Aircraft are also captured. Assume standard features of Aircraft
and schedules. Passengers should be able to print a receipt and also
receive it as email. Iowa Air allows the passenger to change their
reservation free of cost till 2 days before flight departure time. After that
penalties occur but it will be handled through over the counter and
telephone support process.
Phase 2 will involve Direct Flights and the use of Hub system. Phase 3 will
involve Frequent Flier Mileage program, Seat selection and Trans-Atlantic
Flights. Iowa Air seeks that the design must cater to development of these
capabilities without any modifications to the Phase 1 design.
The goal of this phase of project is to create a robust data model and design the
database using the principles taught in the course. A data driven approach is
highly desired.
Customer objectives and scope description
The proposed web portal must be highly extensible and support concurrency.
The goal of this phase of project is to create a robust data model and design the
database using the principles taught in this course.
An urgent requirement is build a state of the art web / mobile application for
above integrated software application. An iterative approach is probably ideal.
The goal is to build an integrated System. A first step is to gather more
detailed requirements and build a good data Model, use Normalization
22C4400 – Database Systems Project – Initial 1/28/2019
Project Scope
Raman Aravamudhan RSA-22C4400-S19-PROJECT-SCOPE
Department of Computer Science Page 2 of 5 Version 1.1
techniques and design the Normalized database catering to excellent
performance in a totally secured environment.
The key is to come up with a good efficient database design which can support
both Mobile and Web browser environments. The user interface is important but
not every screen is required in Phase 1, as the focus is on database. Use of
Stored procedures must be maximized. Focus is on Database aspects of
the project.
The software must be implemented by semester end which means that a well
tested demo system must be launched that time. Customer prefers to see
intermediate versions of the proposed software. ER Model, Normalized
Database, DDL scripts, Database Objects, Screens and some of these functions
must be delivered in that order. Use of ORM like Hibernate (to be taught in this
course) are good capabilities to consider. Customer contacts will provide
additional details of requirements, if requested by the Project team during project
team meetings.
Customer contacts:
Team # Primary Customer contact Alternate Customer contact
All Ingroj RAMAN
General Requirements:
- Data Model, Normalization, Database Design, Stored Procedures should be
as detailed as possible. The user interface and programming will be for
limited functions only (to be identified). Please use AA only for reference.
Kindly use Iowa Air in all your work products. - The tool should be user friendly & require minimal data entry. The Software
development team and the Business analysts are required to suggest the
specific user friendly features while drafting the User Requirement
Specifications. Some examples of user friendly features may be
a. minimum data entry
b. data transfer from context sensitive help screens - The system must support user Id / Password based authentication and must
offer the best security features. The software development team is required
to identify (in URS) the specific security features to be incorporated in
software. Some examples of such security features may be
a. Data encryption techniques (128 bit )
b. Invisible password
c. Structure of Password
d. Password change policy
e. User Id / Password retrieval policy
22C4400 – Database Systems Project – Initial 1/28/2019
Project Scope
Raman Aravamudhan RSA-22C4400-S19-PROJECT-SCOPE
Department of Computer Science Page 3 of 5 Version 1.1
Functional requirements: - Book Flight – Round Trip
- Book Flight – 1 Way
- Book Flight – Multi City
- Book Flight – Award Travel
- Flight Status , Notification
- Aircraft (CRUD)
- Flight (CRUD), Aircraft Assignment for Flight
- Advantage Account
- Advantage Account logging
- Your trips
- News about vacations
- Contact us
- About us
- Advanced Search
- Trip Cancellation and Change
- More to be identified
Non Functional and Operational requirements from project team:
- Each Team must pick a Team Leader and may pick a corporation name
- Team work is very important.
- Team members must have regular meetings each week.(at least 2)
- Meetings should be well planned and should preferably be less than 15
minutes in each meeting. - It is highly recommended that teams meet once after class every week.
- Distributed teams are a matter of fact; technology should be used to meet
from remote, if it is convenient. - Team must submit more detailed schedule and get it approved.
- The work done in each stage of software development must be acceptable to
the customer. - All members of the team must assume specific responsibilities.
- The customer must be informed of the Roles and Responsibilities
- The tools required for the project will NOT be provided by the customer.
- Due to acute shortage of resources, the customer is able to meet with project
teams only on a pre-arranged basis during regular office hours. - Use of Stored procedures must be maximized.
- All documents must be delivered using ICON drop box.
- Teams must develop the Screens and demo the screen flow before
developing the full software. It should be easy to make changes to database design
22C4400 – Database Systems Project – Initial 1/28/2019
Project Scope
Raman Aravamudhan RSA-22C4400-S19-PROJECT-SCOPE
Department of Computer Science Page 4 of 5 Version 1.1
Specific Deliverable schedule: [Due dates to be decided with class, TA]Deliverable Description Due date Weight %
- Project Plan with individual Schedule
- Data Attribute collection, Initial DB creation 2/5/19 5
- User Requirement Specs , Usecase development 5
- Definitions of queries required in English 5
- Test Plans , Testing 5
- ER Model (must be very detailed ) 15
- Normalized database 10
- High Level Design (screens, database, architecture,
De-Normalizations if any) Design must be derived
from model
10 - Demo of Stored procedures, functions 10
- Working software deliverable Iteration 1 10
- Working software deliverable Iteration 2 - Final 10
- Use of advanced DB features - discuss 5
- Final Team Presentations 5
- Team work 5
[Item1] Project Plan. Briefly describe the availability of each team member,
when you plan to meet, roles and responsibilities etc.
[Items 2-3] Project – Functional / User Requirements /Data Attribute
a. List all functions and describe it briefly
b. For each Function list all Data Elements (Input, Output, Persisted or not)
c. For each Data element identify (Data type, Validations, Domain, Constraints,
Key or Not, Size, usage etc.)
d. Write queries in words, GUI , Get Coding skills
Data Attribute collection: Come prepared for project meeting with Data
Attributes collection on 2/5/19
[Items 4] Test Pan (Requirement #, Test condition, Expected result) - How you plan to test tool and its components (stored proc, queries)
- Test Strategies (100%, Black box / white box testing)
- Unit, Module, over all functional
- Traceable to requirements
[Items 5] E-R Model, Normalization [TBA]
[Items 6] DB Design [TBA]
[Items 7-8] Code and Software
Don’t submit it in ICON; Demo it to TA / me; we will ask for code selectively
Iterations - Deliverables
Iteration #1: Screens, Db, Test plans, some data pull, over all architecture
Deliver for the functions included in the iteration
Iteration 2 (Full) – Both should be working software
Suggestion: In each iteration, carry out steps 2-6. So incremental
requirements will be given and agile experience can be provided.
Due Dates flexible within semester constraints. To be discussed in class
22C4400 – Database Systems Project – Initial 1/28/2019
Project Scope
Raman Aravamudhan RSA-22C4400-S19-PROJECT-SCOPE
Department of Computer Science Page 5 of 5 Version 1.1
For Project Meeting (Please be on time, don’t skip without prior approval)
a. What you did this week, where you need help, problems faced etc.
b. What you plan to complete next week
Revision Log
Date Version Description of change
1/27/19 1.0 Initial
1/28/19 1.1 Functional requirements listed
WX:codehelp
今天带大家了解了MySQL的相关知识,希望对你有所帮助;关于数据库的技术知识我们会一点点深入介绍,欢迎大家关注golang学习网公众号,一起学习编程~

- 上一篇
- mysql事务提交总结

- 下一篇
- Mysql专栏 - redo log日志细节
-
- 冷酷的月亮
- 细节满满,码起来,感谢师傅的这篇技术文章,我会继续支持!
- 2023-03-15 07:46:03
-
- 风中的小蜜蜂
- 感谢大佬分享,一直没懂这个问题,但其实工作中常常有遇到...不过今天到这,看完之后很有帮助,总算是懂了,感谢老哥分享文章!
- 2023-03-10 12:56:40
-
- 高大的冰棍
- 这篇博文太及时了,太全面了,赞 👍👍,码起来,关注楼主了!希望楼主能多写数据库相关的文章。
- 2023-02-19 21:32:15
-
- 悦耳的蜡烛
- 这篇文章内容真及时,很详细,写的不错,码住,关注老哥了!希望老哥能多写数据库相关的文章。
- 2023-02-15 23:57:21
-
- 数据库 · MySQL | 2天前 |
- MySQL设置中文界面,超简单教程来了!
- 332浏览 收藏
-
- 数据库 · MySQL | 2天前 | mysql 索引提示
- MySQL进阶必看!FORCE/USE/IGNOREINDEX用法大揭秘
- 182浏览 收藏
-
- 数据库 · MySQL | 2天前 |
- 手把手教你写MySQL存储过程,小白也能轻松上手
- 163浏览 收藏
-
- 数据库 · MySQL | 2天前 | mysql group by
- MySQL分组查询优化:GROUPBY原理+索引优化超全解析
- 324浏览 收藏
-
- 数据库 · MySQL | 2天前 |
- MySQL设置中文语言,轻松拥有中文界面
- 211浏览 收藏
-
- 数据库 · MySQL | 2天前 |
- MySQL建库语句从入门到精通:创建数据库+设置字符集&排序规则(附实例)
- 176浏览 收藏
-
- 数据库 · MySQL | 2天前 |
- 从零开始学MySQL数据库操作,小白轻松变大神!
- 496浏览 收藏
-
- 数据库 · MySQL | 2天前 |
- MySQL插入日期到时间字段,轻松搞定日期格式
- 484浏览 收藏
-
- 数据库 · MySQL | 2天前 | mysql 数据压缩
- MySQL怎么实现高效压缩存储?表压缩+列式存储详细解读
- 272浏览 收藏
-
- 数据库 · MySQL | 2天前 | mysql JOIN优化
- MySQL优化JOIN操作:七大技巧教你提升关联查询速度
- 106浏览 收藏
-
- 数据库 · MySQL | 2天前 |
- MySQL出现中文乱码?超详细解决方案一次性搞定
- 211浏览 收藏
-
- 数据库 · MySQL | 2天前 |
- MySQL主从复制这样配!搞懂这些参数,replication稳了~
- 131浏览 收藏
-
- 前端进阶之JavaScript设计模式
- 设计模式是开发人员在软件开发过程中面临一般问题时的解决方案,代表了最佳的实践。本课程的主打内容包括JS常见设计模式以及具体应用场景,打造一站式知识长龙服务,适合有JS基础的同学学习。
- 542次学习
-
- GO语言核心编程课程
- 本课程采用真实案例,全面具体可落地,从理论到实践,一步一步将GO核心编程技术、编程思想、底层实现融会贯通,使学习者贴近时代脉搏,做IT互联网时代的弄潮儿。
- 508次学习
-
- 简单聊聊mysql8与网络通信
- 如有问题加微信:Le-studyg;在课程中,我们将首先介绍MySQL8的新特性,包括性能优化、安全增强、新数据类型等,帮助学生快速熟悉MySQL8的最新功能。接着,我们将深入解析MySQL的网络通信机制,包括协议、连接管理、数据传输等,让
- 497次学习
-
- JavaScript正则表达式基础与实战
- 在任何一门编程语言中,正则表达式,都是一项重要的知识,它提供了高效的字符串匹配与捕获机制,可以极大的简化程序设计。
- 487次学习
-
- 从零制作响应式网站—Grid布局
- 本系列教程将展示从零制作一个假想的网络科技公司官网,分为导航,轮播,关于我们,成功案例,服务流程,团队介绍,数据部分,公司动态,底部信息等内容区块。网站整体采用CSSGrid布局,支持响应式,有流畅过渡和展现动画。
- 484次学习
-
- 茅茅虫AIGC检测
- 茅茅虫AIGC检测,湖南茅茅虫科技有限公司倾力打造,运用NLP技术精准识别AI生成文本,提供论文、专著等学术文本的AIGC检测服务。支持多种格式,生成可视化报告,保障您的学术诚信和内容质量。
- 23次使用
-
- 赛林匹克平台(Challympics)
- 探索赛林匹克平台Challympics,一个聚焦人工智能、算力算法、量子计算等前沿技术的赛事聚合平台。连接产学研用,助力科技创新与产业升级。
- 50次使用
-
- 笔格AIPPT
- SEO 笔格AIPPT是135编辑器推出的AI智能PPT制作平台,依托DeepSeek大模型,实现智能大纲生成、一键PPT生成、AI文字优化、图像生成等功能。免费试用,提升PPT制作效率,适用于商务演示、教育培训等多种场景。
- 58次使用
-
- 稿定PPT
- 告别PPT制作难题!稿定PPT提供海量模板、AI智能生成、在线协作,助您轻松制作专业演示文稿。职场办公、教育学习、企业服务全覆盖,降本增效,释放创意!
- 53次使用
-
- Suno苏诺中文版
- 探索Suno苏诺中文版,一款颠覆传统音乐创作的AI平台。无需专业技能,轻松创作个性化音乐。智能词曲生成、风格迁移、海量音效,释放您的音乐灵感!
- 60次使用
-
- golang MySQL实现对数据库表存储获取操作示例
- 2022-12-22 499浏览
-
- 搞一个自娱自乐的博客(二) 架构搭建
- 2023-02-16 244浏览
-
- B-Tree、B+Tree以及B-link Tree
- 2023-01-19 235浏览
-
- mysql面试题
- 2023-01-17 157浏览
-
- MySQL数据表简单查询
- 2023-01-10 101浏览