皮皮学,免费搜题
登录
logo - 刷刷题
搜题
【简答题】
阅读下列说明,回答问题1~问题4。 【说明】 某超市的销售业务由一个销售业务管理系统进行管理,该系统每完成一次交易都需要提供顾客发票,其格式见表6所示。 对于这样一个销售业务管理系统,分别给出了以下两种关系数据库的设计(下划线表示主关键字) 设计一: 顾客Customer(顾客代码Cno,姓名name,住址address,联系电话phone) 收银员Salesman(收银员代码Sno,身份证号idno,姓名name,住址address,联系电话 phone) 商品Merchandise(商品代码Mno,商品名称Mname,价格price) 发票Invoice(发票号码Ino,交易日期Idate,顾客代码Cno,收银员代码Sno,商品代码 Mno,单价unitpfice,数量amount) 设计二: 顾客Customer(顾客代码Cno,姓名name,住址address,联系电话phone) 收银员Salesman(收银员代码Sno,身份证号idno,姓名name,住址address,联系电话 phone) 商品Memhandise(商品代码Mno,商品名称Mname,价格price) 发票Ivoice(发票号码Ino,交易日期Idate,顾客代码Cno,收银员代码Sno) 发票明细Invoicedetail(发票号码Ino,商品代码Mno,单价unitprice,数量amount) 设计一的关系模式Invoice最高满足第几范式?为什么?设计一和设计二哪个更加合理?为什么?
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
微信内点击右上角“…”即可分享
反馈
参考答案:
举一反三
【多选题】著名的岩溶山水风景区是()。
A.
漓江山水
B.
路南石林
C.
织金洞
D.
九寨沟风景区
E.
武陵源风景区
【单选题】A seaman you have just discharged has a Continuous Discharge Book. Which statement is TRUE?
A.
The record of entry in the continuous discharge book shall agree with the entry made in the Ship's Articles
B.
If the vessel was on coastwise articles,the record of discharge will be made in the Official Logbook
C.
An entry should be made in the book and a Certificate of Discharge issued to the seaman
D.
A Certificate of Discharge form should be attached to the book
【单选题】According to the professor, who are the most likely to catch swine influenza?
A.
People who expose themselves to swine.
B.
People work for a special program.
C.
People who make intensive studies about swine.
D.
People who would like to take risks.
【单选题】Who is most likely to be chosen as the subject of Zogbys survey?
A.
Those who are conducting prosperous businesses.
B.
Those who are fascinated by thrilling extreme games.
C.
Those who admire the heroic deeds of Alan Shepard.
D.
Those who are healthy enough for the space travel.
【单选题】从天然药物中提取的有效物质,申请中药保护品种的保护期限和延长的保护期限分别为 根据《中药品种保护条例》
A.
10年.10年
B.
10年.20年
C.
10年.14年
D.
7年.7年
E.
7年.10年
【多选题】著名的岩溶山水风景区是( )。
A.
漓江山水
B.
路南石林
C.
织金洞 、九寨沟风景区 E、武陵源风景区
【判断题】企业短期持有的股票上涨或下跌应通过 “公允价值变动损益”科目核算。
A.
正确
B.
错误
【单选题】You discharge garbage overboard at sea. When recording your vessel’s position as required, you must include _____.
A.
 course, speed and estimated distance from shore
B.
latitude, longitude and approximate depth of water
C.
C .latitude, longitude, course, speed and a copy of that days noon position slip
D.
Latitude and longitude
【单选题】Most of those who commit computer crimes will most likely ______.
A.
be forced to leave their own country for other countries
B.
commit suicide in order to escape punishment
C.
be caught, sentenced and then put into prison
D.
be highly recommended to another company
【单选题】You discharge garbage overboard at sea. When recording your vessel’s position as required, you must include _____.
A.
course, speed and estimated distance from shore
B.
latitude, longitude and approximate depth of water
C.
.latitude, longitude, course, speed and a copy of that days noon position slip
D.
Latitude and longitude
相关题目:
参考解析:
知识点:
题目纠错 0
发布
创建自己的小题库 - 刷刷题