Building Accounting Information System using MS Access

hostapd.conf配置文档 ##### hostapd configuration file ############################################## # Empty lines and lines starting with # are ignored # AP netdevice name (without 'ap' postfix, i.e., wlan0 uses wl 阅读详情


Database Assignment (Fall 2024) Building Accounting Information System using MS Access (100 marks)
SPE Limited sells different kinds of smartphones that it purchases from different manufacturers. Its customers purchase their desired products via filling in an online order form in the company website. Peter Watsons started the company 6 years ago and the company revenue has grown four times since its incorporation. Currently, SPE uses MS Excel to record the revenue cycle business activities. However, storing and analyzing the data in MS Excel has numerous limitations. SPE would like to use MS ACCESS to record within the revenue cycle. As the company’s Accounting Manager, you are asked to design and
database for SPE. The following paragraph describes the revenue cycle activities and business rules of SPE.
A customer of SPE places an online order via the website. The order indicates the products that the customer wants to purchase. SPE sends a sales invoice to the customer together with the delivery of the products. When the customer settles the sales invoices, he/she can mail the cheques to SPE or transfer the money to SPE’s bank account through electronic fund transfer. The
, store analyze and report its business activities
           rules are as follow: (i) o with
can
Required:
Assume
1. 2.
but
  inventory item, it can appear in many sales orders
invoice and for each sales invoice, partial settlement by customer is
all accounts’ beginning balances are zero
all transactions happen in January and February 2024
Part I: Design SPE’s database using REA     it using
will
Using Microsoft Access, create the appropriate entities (or tables) based on the data elements given in the appendix. the     key for each entity. Fill in those entities with appropriate data. Decide on the     type between entities based on the business rules described above and the business rules normally adopted by commercial organizations. Link up those entities by joining the primary and foreign key together. You should follow the     as stipulated by the REA diagram and draw the diagram in the relationship view of MS Access. Note that some of the
1
Choose
relationship
ne order can be fulfilled by several sales
or sales, (iii) o
participate in many money receipts, and for each receipt, it can only be participated
one sale can only be associated
ne sales representative / customer
develop this
 participate in one or more order
s or sales
allowed
is     by settles one sales
, (v) each c
participated
business
   one order, (ii) each sales order or sale can include one or more inventory items and for each
  only one sales representative / customer, (iv) e
events and each order or sale event
 ach
money
receipt from a customer
   not
ashier
    / customer
can
    by one cashier / customer, (vi) each receipt
 bank account can take many money receipts.
be deposited into one single bank account and the
      diagram
and draw
Microsoft
 Access
 primary
(20 marks)
 pattern
  
relationship types between entities may be unspecified and you need to think critically and make your own judgement based on the materials that you learn in class.
   Part II: Build the
 database
 using ACCESS
 Create a database file using your session weekday and student IDs as filename. guidelines in coming up with the data of the tables.
Required number of
Create at least 5 customers
Create at least 7 inventory items
Create at least 8 sales orders, with 5 in Jan. and 3 in Feb. 2024 Create at least 10 sales, with 6 in Jan. and 4 in Feb. 2024
(30 marks)
Use the following
  entries
 (records)
        Create at least two employees: one salesman, one cashier. Use your full name(s) as employee name(s). If two students work together, then one student acts as salesman and the other student acts as cashier.
 Create at least 8 money receipts, with 2 in Jan. and 6 in Feb. 2024. There should be at least one sales invoice that has not been settled in your database.
Create at least 1 bank account
Point to note when you create your data:
The data created should be consistent with the type of relationship. That is, if the relationship is many-to-many (one-to-many), you must come up with table(s) and data that illustrate the many-to-many (one-to-many) relationship.
Hints:
If a sales invoice includes many inventory items and you want to show the quantity sold for each item, it is not feasible to include the “Quantity Sold” field in the sales table because each sale is represented by only one row in the sales table. If you include inventory # as one of the fields in the sales table, you can only sell one inventory # in each sales invoice given there is only one cell for input.
Leave the Receipt # as blank in the Sales table if customer has not made any payment to settle an invoice. You can retrieve these sales by using the criteria: is null, within the receipt # field.
2
   
1. Generate
i the January 2024 sales report; in your query output, you should display the following information: sales invoice date, sales invoice number, sales invoice amount, customer #, employee # and receipt #. (10 marks)
ii the total January revenue using the query in (i). (5 marks)
iii the January 2024 gross margin by inventory item; in your query output you should display the following information: inventory item#, inventory item description, sum of quantity sold, unit price, unit cost, total revenue, total cost of goods sold and gross margin amount
and gross margin percentage. (10 marks)
(Hints for iii: If you use two queries, the first query takes out those sales in January. The second query utilizes the first query to calculate total revenue, total cost of goods sold and gross margin. In the second query, do not include any date field.)
2. Which inventory item is most popular in terms of total sales quantity for the two months combined? Rank the quantity sold in descending order. Your output should display inventory item#, inventory item description and sum of quantity sold. (No date field is necessary as you are including all sales data in both January and February) (7 marks)
3. Assume a sales commission rate of 5%, generate a report that shows the commission income by salesman for January. The commission income is based on the total sales made by a salesman multiplied by the commission rate. Your report should show employee #, employee name and commission. (Hint: use one of the tables and query 1(i)). (8 marks)
4. Which customers have not settled their sales invoices? Generate a report that shows the following fields: sales invoice #, sales invoice date, customer #, customer name, employee #, employee name, and receipt #. (10 marks)
(50 marks)
Part III:
 Query
 your database
 3

Appendix
The following data elements and types are given to you. You may leave some of the data elements nil entries as they are not relevant in generating the queries in part III. Example of those
data elements are Address, Telephone, Credit Limit, Date Hired, Date of Birth, etc. some of the data elements may appear in more than one table.
Note that
Field
Customer #
Customer Name
Customer Address Customer Telephone Credit Limit
Employee #
Employee Name Employee Title Commission Rate
Base Salary
Date Hired
Date of Birth
Sales Order #
Sales Order Date
Quantity Ordered
Sales Invoice #
Sales Invoice Date Inventory Item #
Inventory Item Description Unit Price
Unit Cost
Quantity sold
Receipt #
Receipt Date
Receipt amount
Bank Account #
Bank Account Type
Bank Account Balance
Note:
Date Type
Text or Number Text
Text
Text
Currency or Number Text or Number Text
Text
Number
Currency or Number Time/Date Time/Date
Text or Number Time/Date
Number
Text or Number Time/Date
Text
Text
Currency or Number Currency or Number Number
Text
Time/Date
Currency or Number Number
Text
Currency or Number
1. Credit Limit means the dollar limit that SPE gives to a customer.
information purposes. Students can leave it as blank as the query does not use this field.
2. Example of bank account type is saving account or checking account. You could have zero in the bank account balance as the query does not use this field.
-End-
This field is only for
 

SpringBoot+Vue+MySQL 高校学科竞赛平台 完整可运行版(源码+文档) 本项目基于SpringBoot+Vue+MySQL构建高校学科竞赛管理平台,覆盖学生、教师、领队教师、管理员四大角色,实现竞赛发布、报名、刷题、评分、公示等全流程闭环管理。系统架构清晰,技术主流,配套完整源码、数据库脚本、万字论文、开题报告、答辩PPT及部署文档,支持一键运行,适用于毕业设计、课程设计及院系二次开发,真正实现“开箱即用”。 阅读详情

相关推荐

【深度学习3】ubuntu22.04从零开始搭建深度学习环境

ubuntu22.04从零开始搭建深度学习开发环境

weixin_43387635的博客 1万+

GG3M (鸽姆)划时代科技前沿AI项目:文明级操作系统,东方智慧驱动全球治理新范式——核心问题解答(11问11答)

GG3M是以“贾子智慧理论”为根基,融合东方哲学与前沿科技构建的“智慧文明级操作系统”。其核心旨在将全球治理从经验体系升级为可计算、可预测、可迭代的科学模型。项目涵盖文化科技、智慧决策、教育培养及全球治理基础设施四大业务板块,通过Meta-Mind-Model框架,整合量子技术、AI与文明量化工具,推动文明从“碳基”向“智慧”范式跃迁。目前处于种子轮阶段,计划融资5000万至2亿美元,致力于成为全球治理的底层架构与价值标准制定者。

首席技术执行官CTO(Chief Technology Officer)|技术总监--邓斌博客 1537

QtNodeEditor实战:构建高效可视化编程环境的完整指南

本文是QtNodeEditor实战的完整指南,详细介绍了如何利用这一基于Qt框架的可视化编程工具构建高效节点编辑器。内容涵盖从快速集成、自定义节点模型到深入理解MVC数据流架构,并提供了样式定制、场景序列化、动态端口等高级功能的实现方法,帮助开发者快速搭建灵活、可维护的可视化编程环境。

lemon的博客 702

第二周作业

⑥Rocky 9.5 和 Rocky 9.7 能使用相同的软件源(仓库)吗?源码编译,gcc make&&make install 执行二进制源码文件。④离线服务器(Rocky/Ubuntu)如何安装nginx(包括依赖包)⑤Rocky 9 和 Rocky 10 能使用相同的软件源(仓库)吗?③apt remove 和 apt purge 有什么区别?Rocky,虚拟机能访问外网,镜像源地址选择阿里镜像源。⑦Ubuntu 24.04 和26.04 软件源通用吗?不通用,大版本软件源隔离。

qq_45724363的博客 227

压电阀控制器设计-总章

本文章用于回顾记录本人制作压电阀控制器的关键技术,本人所制作压电阀控制器已经上市得到应用,特在此对一些关键技术进行回顾记录,欢迎从事压电控制及压电阀相关人员一起讨论

qq_42712859的博客 850

3D Slicer + MONAI Bundle实战:如何用Wholebrainseg模型快速分割133个脑区(附避坑指南)

本文详细介绍了如何利用MONAI Model Zoo中的Wholebrainseg模型,在3D Slicer环境中高效分割133个脑区。文章重点提供了数据预处理、GPU推理加速及结果精修等实战技巧与避坑指南,旨在帮助医学影像研究者和开发者提升全脑分割的精度与效率。

314

177.Agent-LangGraph-MCP的构成说明

MCP架构通过MCP主机、客户端与服务器的协同,实现工具、资源与提示词的统一管理。MCP服务器提供Tools、Resources、Prompts能力,MCP客户端则负责发现、调用与读取,使Agent可按需获取上下文。其核心在于将工具从Agent中抽离,封装为可复用的服务,提升灵活性与可维护性,推动AI应用高效协作。

计算机王的博客 315

uniCloud云存储进阶:七牛云扩展存储从开通、绑定域名到批量上传的完整实战

本文详细介绍了uniCloud云存储进阶实践,重点讲解如何通过七牛云扩展存储实现从开通、绑定域名到批量上传的完整流程。内容涵盖成本优势分析、域名备案方案、SSL证书配置、多文件并发上传控制等实战技巧,并提供可直接复用的代码示例,帮助开发者高效构建内容社区类应用。

weixin_26985923的博客 470

Docker Compose:搭建本地多服务开发环境

从一个 Java API、PostgreSQL 和 Redis 开始,配置服务名、端口、环境变量、健康检查、数据卷和依赖关系。理解 Compose 文件如何被解析、项目如何隔离,以及哪些数据不能依赖“重建容器”保留,能够把个人开发环境整理成团队可复用的启动入口。

m0_62221377的博客 478

UNet 改进(27):结合SCSE注意力机制的UNet网络实现

本文介绍了一种结合SCSE注意力机制的改进UNet网络架构。该网络在保持UNet经典编码器-解码器结构基础上,通过在每层添加SCSEBlock模块,融合了通道注意力和空间注意力机制。通道注意力通过全局池化和1×1卷积生成通道权重,空间注意力则产生空间权重图,二者相加增强关键特征响应。该设计具有以下优势:1)保持原始UNet的多尺度特征提取能力;2)通过注意力机制提升对重要区域的关注度;3)计算效率高,仅增加少量参数。测试显示网络能保持输入输出分辨率不变,适用于医学图像分割等像素级预测任务。完整代码实现了5层

2401_82355416的博客 415

【四足机器人实战】四足机器人运动学、动力学模型

认知有限,望大家多多包涵,有什么问题也希望能够与大家多交流,共同成长!四足机器人的运动学和动力学模型是其设计和控制的基础,涉及到如何精确描述和预测机器人在不同条件下的运动状态和行为本文先对四足机器人运动学、动力学模型做个简单的介绍,具体内容后续再更,其他模块可以参考去我其他文章运动学模型主要关注四足机器人的几何形态和时间序列下的运动特性,而动力学模型则进一步考虑了引起这些运动的力和扭矩的作用效果。运动学模型:运动学模型描述了四足机器人在没有考虑力的影响下的运动特性。

qq_35635374的博客 1057

AI全栈实战 | 3.9-01 爬虫入门:requests 加 BeautifulSoup 三分钟跑通,但 90% 的人栽在这 4 个“礼貌“问题上

⚠️:本文内容仅用于。请遵守目标站点的服务条款与相关法律法规,不得对目标服务造成负担,不得采集、传播个人隐私数据。技术是中性的,边界在你手里。爬虫的入门技术(requests 发请求 + BeautifulSoup 解析)三分钟就能学会。真正区分"会用爬虫"和"会做爬虫的人"的,是这篇我们跑通"请求→解析→存储"的最小闭环,然后重点把"合规与礼貌"这根弦给你绷上。

源码获取 | 运行部署 | 定制二开修改,如果回复不及时请耐心等待,请见谅。 444

【FISCO-BCOS】 八、ubuntu配置Java环境

ubuntu配置Java环境需根据自己的java版本号进行细节修改,本文以jdk11.0.18版本为例。ps:通过此法还可以查看java安装路径,但必须是环境配置成功的情况下才能使用。二、添加Java环境路径。四、检查java环境设置。

naihe_fish的博客 4318

spring boot 4集成SQLLite,及其SQLLite的建库

spring boot 4集成SQLLite,及其SQLLite的建库

weixin_41463944的博客 238

jre9下载 jdk9

(Java SE Runtime Environment 9.0) 9.0u175 官方最新版 【x86|x64】

文档:亲测可用解决vnc灰屏,黑屏,鼠标大黑叉情况

主要解决vnc-viewer灰屏,黑屏,鼠标大黑叉等现象,详细见文档。

【基于 WebSocket 的多用户网页五子棋】—— 数据管理模块

但行好事,莫问前程

qq_42996461的博客 260

Statistics and Machine Learning Toolbox

Statistics and Machine Learning Toolbox(带书签),MATLAB统计学习工具

OpenClaw 深度调查:把 AI 助手做成你自己的控制平面

对 openclaw/openclaw 的完整技术尽调:Gateway 架构、Agent 运行时、工具与沙箱、30 个消息通道、181 个插件、安全信任边界、工程代价与采用建议。17 章 / 10 张图,全部数字标注口径,数据截至 2026-10-31。

厚积薄发 351

大中型超市收银系统(可直接运行)

光步前台收银系统系统功能:商品销售、商品退货、挂单、收银员权限、会员销售、单品取消、整单取消、商品查询、脱机销售、脱机数据上传,基本资料下载,开钱箱、小票打印、收款结算,支持多币种付款方式(现金、储值卡、礼券、微信等),支持多种促销。运行环境:.net 4.0登陆信息用户名:1001 密码:123456内置商品信息,商品编码可输入00001000 - 00010000,测试效果相关功能键F5 结算 F9挂单 F11商品查询 F8退货 Insert单品取消 Del整单取消 F12开钱箱F2 会员 Ctrl+Z退出系统 Home 锁屏 相关源码待公开

IDEA 简介:从零认识 IntelliJ IDEA

IDEA 全称,是由 JetBrains 公司开发的一款主流 Java 集成开发环境(IDE)。它集代码编辑、编译、调试、测试、版本控制、构建管理等功能于一体,被大量 Java 开发者视为日常开发的首选工具。所谓 IDE(Integrated Development Environment,集成开发环境),就是把写代码所需的各类工具整合到同一个界面中。相比只用文本编辑器加命令行编译,IDE 能显著减少重复操作,让开发者把精力集中在业务逻辑上。

ztI10的博客 185

TransactionInactiveError:await 之后事务已经不活跃了

TransactionInactiveError 出现于 IndexedDB 事务已结束(非 active 状态)时调用 put、get 等操作。常见于 await 后或 setTimeout 中执行请求,因任务已完成,事务已提交或进入 finished 状态。请求必须在创建事务的同一任务中挂起,否则无效。解决方法:在 onsuccess 回调内同步发起后续操作,或提前将所有请求挂入事务。避免在异步上下文中使用事务操作,确保请求在事务活跃期内完成。

qq_40822000的博客 160

Docker部署linkding:HTTPS与数据备份

部署私人书签库,除了让页面能够打开,还需要考虑几个实际问题:重建容器后数据是否保留、登录和保存是否正常、升级前怎样备份,以及出现 502 或 CSRF 错误时从哪里检查。本文使用 Docker Compose 部署 linkding,采用默认 SQLite 数据库,通过 Caddy 提供 HTTPS,并完成账户创建、数据持久化验证和备份。如果重建后账户或书签消失,应先检查是否换了项目目录、改了挂载路径,或者启动了另一套实例,不要急着重新初始化。遇到权限问题,应根据日志确认具体目录和运行用户,再调整权限。

tedcloud123的博客 194

云计算课程小组PPT汇报任务书

36人分为6组,每组6人;形式:生活案例调研 + 理论解读;汇报时长7‑9min;PPT建议10‑14页。

Michelle8023的博客 228

企业官网源码与数据资产交接:四项权利、五组自动检查

企业官网源码交接不仅要看压缩包,还要核域名、云资源、构建脚本、数据库恢复、权限与密钥。

sweetofmine1的博客 187

软件项目交付时,源代码之外还应该交付哪些技术资料?

软件项目交付时,除可运行程序外,还应核对源代码、数据库结构、接口文档、部署运维、测试验收和账号资产。本文从实际交付环节拆解完整资料清单,并说明合同如何约定交付范围、知识产权与维护边界。

chengduyoushu的博客 308

Java 项目实战:交友项目后台系统——网关统一鉴权与 B 端管理后台

本次改造通过引入SpringCloud Gateway实现网关统一鉴权与路由,新建mf-admin管理端复用C端域服务(Dubbo调用),实现管理员登录与用户管理四件查询。核心套路:网关白名单+双体系JWT(同工具不同payload)、管理端零直连业务库、分页形态区分(MySQL自动count/Mongo手动count)、浏览器端独立聚合。踩坑12条,附自检清单与后续改造方向,可复用于多角色后台系统。

Wang的专栏 70

大表 ALTER TABLE 怎么做?NineData OnlineDDL 配置与执行实践

介绍NineData OnlineDDL大表变更实践,涵盖执行策略、切表控制、拷贝批次与可视化进度追踪。

dbasenewbie的博客 295

Axum 初步入门学习笔记

)自定义错误实现后,可以直接作为Result的ErrAxum 是一个构建在 Tokio、Tower、Hyper 之上的 Rust Web 框架,核心能力是:Router 路由、Extractor 提取器、Tower 中间件、IntoResponse 响应机制、State 共享状态。那张分层架构图是“地图”不是“说明书”:它帮你建立全局观,但 Service、Repository、数据库、Redis、MQ 都是你自己在 Handler 内部调用的业务/基础设施层,不是 Axum 自带的。

weixin_43219667的博客 206

MySQL报Too many open files?句柄耗尽的排查与参数配置

文章讲清 max_connections 与 open_files_limit 两个额度、句柄被谁占走、分区表为什么最容易踩,给出从 error log 到 /proc/pid/limits 的定位顺序与句柄预算算法。

「一个在数据库赛道上边学边分享的学妹」——聚焦国产数据库/信创方向、分享学习笔记、踩坑经验和行业观察。 338
上一篇: AM05 Workshop 2 - Data acquisition
下一篇: Retail Geography
WX_codehelp
博客等级 码龄2年 700粉丝 87原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付:10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值