文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > IT/计算机 > 电脑基础知识 > 数据库系统实现(第二版)答案ch3
侵权投诉

数据库系统实现(第二版)答案ch3

Database System Implementation

Solutions for Chapter 3

Solutions for Section 3.2

Exercise 3.2.1 First, note that SQL2 dates require 10 bytes, and SQL2 times require 8 bytes if there is no decimal point; this material is in Section 3.1.3.

a)

The bytes requirsed by each of the fields is 15 + 2 + 10 + 8 = 35.

b)

Round each of the four field lengths up to a multiple of 4, to get 16 +

4 + 12 + 8 = 40.

c) Round up again, to a multiple of 8, to get 16 + 8 + 16 + 8 = 48.

Exercise 3.2.3 The elements in the header also require rounding upward in (b) and (c). Thus, the lengths including header fields and adding the lengths for the bodies as calculated in Exercise 3.2.1 are:

a)

4 + 4 + 1 + 35 = 44.

b)

4 + 4 + 4 + 40 = 52.

c)

8 + 8 + 8 + 48 = 72. Exercise 3.2.5

For parts (a) and (b), the header takes 40 bytes, while for (c) it takes 80

数据库系统实现(第二版)答案ch3

bytes. The calculations are thus:

第1页

你可能喜欢

热门文档

相关文档

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email