数据库系统概论 第七章课后习题(部分)

本文是《数据库系统概论》的第七章的部分课后习题,题目来源:【2019-2020春学期】数据库作业16:第七章: 数据库设计

📋共有四题


第7题

该题的实体型有:学校、系、班级、教研室、学生、教员、课程
联系包括:

学校和系:1:n ,系和班级:1:n , 系和教研室:1:n
班级和学生:1:n , 教研室和教员:1:n , 教员和学生:1:n
学生和课程:m:n

E-R图是在这个网站在线做的:ProcessOn(用着感觉还行😁)
在这里插入图片描述


第8题

该题的实体型有:产品、零件、材料、仓库
联系包括:

产品和零件:m:n ,零件和仓库:m:n
零件和材料:m:n , 仓库和材料:1:n

E-R图如下&#

  • 54
    点赞
  • 144
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
数据库系统概念(杨冬青)习题答案Chapter 1 provides a general overview of the nature and purpose of database systems. The most important concept in this chapter is that database systems allow data to be treated at a high level of abstraction. Thus, database systems differsignificantly from the file systemsand general purpose programming environments with which students are already familiar. Another important aspect of the chapter is to provide motivation for the use of database systems as opposed to application programs built on top of file systems. Thus, the chapter motivates what the student will be studying in the rest of the course. The idea of abstraction in database systems deserves emphasis throughout, not just in discussion of Section 1.3. The overview of the structure of databases is, of necessity, rather brief, and is meant only to give the student a rough idea of some of the concepts. The student may not initially be able to fully appreciate the concepts described here, but should be able to do so by the end of the course. The specifics of the E-R, relational, and object-oriented models are covered in later chapters. These models can be used in Chapter 1 to reinforce the concept of abstraction, with syntactic details deferred to later in the course. If students have already had a course in operating systems, it is worthwhile to point out how the OS and DBMS are related. It is useful also to differentiate between concurrency as it is taught in operating systems courses (with an orientation towardsfiles, processes,and physical resources)and database concurrency control (with an orientation towards granularity finer than the file level, recoverable transactions, and resources accessed associatively rather than physically). If students are familiar with a particular operating system, that OS’s approach to concurrent file access may be used for illustration.

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值