Cha 4 solutions manual 11th edWord文档下载推荐.docx
- 文档编号:19530969
- 上传时间:2023-01-07
- 格式:DOCX
- 页数:32
- 大小:1.07MB
Cha 4 solutions manual 11th edWord文档下载推荐.docx
《Cha 4 solutions manual 11th edWord文档下载推荐.docx》由会员分享,可在线阅读,更多相关《Cha 4 solutions manual 11th edWord文档下载推荐.docx(32页珍藏版)》请在冰豆网上搜索。
∙Tofilloutasalesorder,thesalesorderentryclerkneedsaccesstothefollowingdatastoredinthedatabase
-itemnumber
-description
-quantity-on-hand
-price
-customername
-shippingaddress
-creditlimit
∙Tocreateandmailabill(invoice),thebillingclerkneedsaccesstothefollowingdatastoredinthedatabase:
-customernumber
-billingaddress
-itemnumbers
-quantitysold
-terms
∙Tomanageinventory,theinventorycontroldepartmentneedsaccesstothefollowingdatastoredinthedatabase:
-description,
-quantityonhand.
∙Topurchaseinventory,thepurchasingdepartmentneedsaccesstothefollowingdatastoredinthedatabase:
-quantityonhand
-cost.
b.Thesetofnecessarytablesincludesthefollowing
TableName
PrimaryKey
ForeignKeys
OtherAttributes
Inventory
ItemNumber
Cost(standardorlist)
Description
QuantityonHand
Price(standardorlist)
Sales
Invoicenumber
Customernumber
Dateofsale
Terms
Sales-Inventory
Itemnumber
Quantitysold
Price(actualsalesprice)
Customer
Customername
Shippingaddress
Billingaddress
CreditLimit
4.2
a.DDL-thisisthelanguageusedtodefinethedatabase.
bDQL-thisisanexampleofaquery.
cDML-thisisthelanguageusedtoactuallyprocesstransactiondataandupdatethedatabase.
d.DQL-anotherexampleofataskthatinvolvesqueryingthedatabase.
e.DDLandDML-theformertoalterthestructure,thelattertomakethechange.
f.DQL-suchalistingcanbeproducedbyaquery.
g.DDLandDML-theformertoaddthefield,thelattertoenterdatainit.
4.3Belowisasetoftablesthatanswerspartsa,b,andc.
Thereisnosolutiontopartsdthroughfasstudentswillselectdifferentsoftwarepackagesandcomeupwithdifferentqueries.
Purchases
Purchaseordernumber
Vendornumber
PurchasingAgent(employeenumber)
Dateofpurchase
Totalamountofpurchase
Purchases-Inventory
Quantitypurchased
Unitcost(actual)
Extendedamount
Vendor
Vendorname
Vendoraddress
Employees
Employeenumber
Employeename
Note:
ExtendedamountandTotalamountofpurchasedonothavetobestoredinthedatabaseastheycanbecalculatedfromothervalues.ExtendedamountisQuantitypurchasedxUnitcost.Totalamountofpurchaseisthesumofalltheextendedamountsforallitemsonaparticularpurchaseorder,
4.4
AnswersdependuponthespecificDBMSandquerylanguageused.HerearesuggestedanswersinQBE(QueryByExample)preparedinMicrosoftAccess.
a.Query
QueryResult
b.Query
c.Query
QueryResult
d.
Thisquestionrequirestheuseofatotalinvoicecalculation,thus,atotalinvoicetableispreparedasaMicrosoft“MakeTableQuery”inMicrosoftOffice.AMakeTableQueryispreparedexactlythesameasanormalqueryexceptthattheuserselectstheMakeTableQueryoptionundertheQueryDesignmenutab.
MakeTableQuery
TableResult
Query
e.Query
f.Query
QueryResult
g.Query
4.5AnswersdependuponthespecificDBMSandquerylanguageused.HerearesuggestedanswersinQBE(QueryByExample)preparedinMicrosoftAccess.
a.Query
QueryResult
b.Query
QueryResult
d.
e.Query
g.Questionsgandirequiretheuseofatotalcustomersalescalculation,thus,acustomertotalsalestableispreparedasaMicrosoft“MakeTableQuery”inMicrosoftOffice.AMakeTableQueryispreparedexactlythesameasanormalqueryexceptthattheuserselectstheMakeTableQueryoptionundertheQueryDesignmenutab.
Make-TableQuery
TableResult
Query
h.Query
i.Query
4.6Thenecessarytables,withtheirattendantprimaryandforeignkeys,areasfollows:
Employee
EmployeeNumber
Supervisornumber(anotheremployeenumber)
Payrate
Datehired
Dateofbirth
Skills
Skillnumber
Skillname
Employees-Skills
Employeenumber
Dateskillacquired
Thereisnosolutiontopartcasstudentswillselectdifferentsoftwarepackagesandenterdifferentdatainthetables.
4.7Thefollowingadditionaltables,withtheirattendantprimarykeys,areneededtostoretheothernewattributes.Notethatcustomernameisalreadystoredinthecustomertable
CashReceipts
CashReceiptNumber
Employeeprocessing
payment(employeenumber)
Dateofreceipt
Totalamountreceived
CashReceipts-Sales
Invoicepaymentapplies
to(Invoicenumber)
CashReceiptnumber
Amountappliedtoa
specificinvoice
4.8
Toavoidtheupdate,insert,anddeleteanomaliesinTable4-17(shownbelow),threeseparaterelationaltables(InvoiceTable,Invoice-InventoryTable,andCustomerTable)arecreated.
TABLE4-17
Invoice#
Date
OrderDate
CustomerID
CustomerName
Item#
Quantity
52
6-19-05
5-25-05
201
Johnson
103
5
122
8
10
11
71
12
57
6-20-05
6-01-05
305
Henry
535
18
115
15
INVOICETABLE
INVOICE-INVENTORYTABLE
Invoice#(PK/FK)
Item#(PK/FK)
CUSTOMERTABLE
PK-PrimaryKey
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Cha solutions manual 11th ed 11 th