• 所有问题

    • 谁帮我设计一个酒店订房的数据库表?送上20分感谢

    就是一个酒店要进行会员制订房,把重点放在突出会员制上,特殊功能上做到区分国籍.
    要求标注出主键和外键

    回答满意再加10分

    举报该问题
    其他回答
    第1个回答  2012-05-25
    数据库举例：
    -------------------------------------------------------------
    CREATE TABLE [dbo].[roomtype](
    [pk] [int] IDENTITY(1,1) NOT NULL,
    [r_type_num] [varchar](50) NOT NULL,
    [room_type] [varchar](50) NOT NULL,
    [bed] [int] NOT NULL,
    [price] [float] NOT NULL,
    [foregift] [float] NOT NULL,
    [cl_room] [varchar](50) NOT NULL CONSTRAINT [DF_rommtype_cl_room] DEFAULT ('N'),
    [cl_price] [float] NULL,
    [remark] [varchar](50) NULL,
    [sysmark] [int] NOT NULL CONSTRAINT [DF_rommtype_sysmark] DEFAULT (0),
    [delmark] [int] NOT NULL CONSTRAINT [DF_rommtype_delmark] DEFAULT (0),
    [other1] [varchar](50) NULL,
    [other2] [varchar](50) NULL,
    CONSTRAINT [PK_rommtype] PRIMARY KEY CLUSTERED
    (
    [pk] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
    CONSTRAINT [IX_roomtype] UNIQUE NONCLUSTERED
    (
    [pk] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    GO
    SET ANSI_PADDING OFF
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'roomtype', @level2type=N'COLUMN',@level2name=N'pk'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'房间名简称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'roomtype', @level2type=N'COLUMN',@level2name=N'r_type_num'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'房间类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'roomtype', @level2type=N'COLUMN',@level2name=N'room_type'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'床位数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'roomtype', @level2type=N'COLUMN',@level2name=N'bed'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'roomtype', @level2type=N'COLUMN',@level2name=N'price'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'押金' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'roomtype', @level2type=N'COLUMN',@level2name=N'foregift'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否为钟点房' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'roomtype', @level2type=N'COLUMN',@level2name=N'cl_room'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'钟点房房价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'roomtype', @level2type=N'COLUMN',@level2name=N'cl_price'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'roomtype', @level2type=N'COLUMN',@level2name=N'remark'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统级标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'roomtype', @level2type=N'COLUMN',@level2name=N'sysmark'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'roomtype', @level2type=N'COLUMN',@level2name=N'delmark'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'其他1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'roomtype', @level2type=N'COLUMN',@level2name=N'other1'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'其它2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'roomtype', @level2type=N'COLUMN',@level2name=N'other2'
    GO
    /****** 对象: Table [dbo].[destine] 脚本日期: 05/25/2012 15:56:02 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    CREATE TABLE [dbo].[destine](
    [pk] [int] IDENTITY(1,1) NOT NULL,
    [client_name] [varchar](50) NOT NULL,
    [client_tel] [varchar](50) NOT NULL,
    [room_type_id] [varchar](50) NOT NULL,
    [room_no] [varchar](50) NOT NULL,
    [main_roomnum] [varchar](50) NOT NULL,
    [pa_time] [datetime] NOT NULL,
    [keep_time] [datetime] NOT NULL,
    [eng_time] [varchar](50) NOT NULL,
    [remark] [varchar](50) NULL,
    [engagemark] [int] NOT NULL CONSTRAINT [DF_destine_engagemark] DEFAULT (0),
    [cluemark] [int] NOT NULL CONSTRAINT [DF_destine_cluemark] DEFAULT (0),
    [delmark] [int] NOT NULL CONSTRAINT [DF_destine_delmark] DEFAULT (0),
    [other1] [varchar](50) NULL,
    [other2] [varchar](50) NULL,
    CONSTRAINT [PK_destine] PRIMARY KEY CLUSTERED
    (
    [pk] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    GO
    SET ANSI_PADDING OFF
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'destine', @level2type=N'COLUMN',@level2name=N'client_name'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'destine', @level2type=N'COLUMN',@level2name=N'client_tel'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'房间类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'destine', @level2type=N'COLUMN',@level2name=N'room_type_id'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'房间号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'destine', @level2type=N'COLUMN',@level2name=N'room_no'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主房间号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'destine', @level2type=N'COLUMN',@level2name=N'main_roomnum'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预抵时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'destine', @level2type=N'COLUMN',@level2name=N'pa_time'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保留时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'destine', @level2type=N'COLUMN',@level2name=N'keep_time'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预定时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'destine', @level2type=N'COLUMN',@level2name=N'eng_time'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'destine', @level2type=N'COLUMN',@level2name=N'remark'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预定状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'destine', @level2type=N'COLUMN',@level2name=N'engagemark'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提醒标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'destine', @level2type=N'COLUMN',@level2name=N'cluemark'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'destine', @level2type=N'COLUMN',@level2name=N'delmark'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'其它1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'destine', @level2type=N'COLUMN',@level2name=N'other1'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'其它2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'destine', @level2type=N'COLUMN',@level2name=N'other2'
    GO
    /****** 对象: Table [dbo].[useradmin] 脚本日期: 05/25/2012 15:56:02 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    CREATE TABLE [dbo].[useradmin](
    [pk] [int] IDENTITY(1,1) NOT NULL,
    [userid] [varchar](50) NOT NULL,
    [pwd] [varchar](50) NOT NULL,
    [puis] [int] NOT NULL,
    [delmark] [int] NOT NULL CONSTRAINT [DF_user_delmark] DEFAULT (0),
    [other1] [varchar](50) NULL,
    [other2] [varchar](50) NULL,
    CONSTRAINT [PK_user] PRIMARY KEY CLUSTERED
    (
    [pk] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
    CONSTRAINT [IX_useradmin] UNIQUE NONCLUSTERED
    (
    [userid] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    GO
    SET ANSI_PADDING OFF
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户登陆ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'useradmin', @level2type=N'COLUMN',@level2name=N'userid'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户登陆密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'useradmin', @level2type=N'COLUMN',@level2name=N'pwd'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户权限' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'useradmin', @level2type=N'COLUMN',@level2name=N'puis'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'useradmin', @level2type=N'COLUMN',@level2name=N'delmark'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'其它1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'useradmin', @level2type=N'COLUMN',@level2name=N'other1'
    GO
    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'其它2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'useradmin', @level2type=N'COLUMN',@level2name=N'other2'
    GO
    -------------------------------------------------------------
    有需要请加百度HI详谈可以远程支持。追问

    不必这么详细,我写个论文,只用一个表就行了
    能不能给我个如下的格式
    table_1:属性1(主键),属性2
    table_2:属性........

    追答

    useradmin：pk（主键), userid, pwd
    ......
    可以加百度HI支持。

    相似回答
    酒店信息管理系统论文答：从酒店管理信息系统的表现形式看,就是指对大量酒店常规信息的输出、处理、存储以及输入。在一定意义上讲,管理信息系统是最大的人工管理协助者。从酒店管理信息系统在个酒店的实际应用情况来看,其主要作用有以下几个方面的表现: 1.可以推动酒店运作效率的提高 酒店每天在为客人提供结算账单、提供查询、登记信息的记录、...
    我要一篇酒店管理的毕业论文,谁能帮下忙啊答：我的毕业设计题目就是设计一个酒店管理系统,在前期的考察和分析之后,对系统进行了设计,虽然受水平所限,实践经验十分匮乏,独立完成一套完备的优秀的酒店管理系统有很大的难度,但是我努力在实践中巩固以及整理自己在大学期间所学的知识,尽量把这个系统设计的更好。目录第一章 引 言 31.1酒店管理系统的引入。 31.1.1...
    住酒店好评大全最新住酒店好评大全最新文案答：举个栗子:酒店的服务非常人性化,第一次到邛崃旅游,感谢酒店的经理给了我很多关于邛崃旅游的线路,入住来邛崃旅游,还要住他们家酒店。酒店回复:亲~~:非常感谢您对我们酒店服务的高度评价。我们酒店会跟进客人到邛崃旅游的次数,设计了2套旅游线路,就像您说你是第一次到邛崃旅游,我们为您提供的路线酒店邛崃最经典的旅游...
    基于b/s的酒店管理系统设计与实现答：基于 B /S 模式的酒店管理系统的设计与实现 XXXXX学院 电大工作部， XX省 XX 457000)摘要:酒店客房管理系统可以实现酒店内各个客房信息以最快、最准确、 最全面的形式传输、 共享， 是酒店前后台联网的一个 网络系统。本系统采用基于 B /S 结构和关系数据库相结合的开发平台，在 Jbuider10 这种开发...
    谁可以帮忙做下这个题目呀 数据库课程设计答：在做实训前,老师先给我们讲了数据库如何导入EXCL表,在老师的指导下我们学会了,为创建表提供了方便。首先我们是建立了一个新的KCSJ数据库,建立的数据语句如下: 用SQL语句在D:\KCSJ下创建课程设计数据库(KCSJ)(一)CREATE DATABASE KCSJON (NAME=KCSJ_DATA, FILENAME='D:\KCSJ_DATA.MDF')LOG ON(NAME=KCSJ_...
    大家正在搜
    设计一个商品数据库的表数据库一对一表设计数据库表设计变成了三个网站分类数据库表设计数据库表怎么设计多对多数据库表设计数据库表设计要考虑什么数据库表关系设计数据库用户表设计
    相关问题
    简单的酒店客房管理数据库
    求酒店订房数据库设计?
    一个酒店mysql数据库，表内有20个字段，其中地址和行政区...
    谁知道广交会是什么时候啊?急急急急
    澳大利亚自助旅游，谁可以帮忙设计一份旅游路线行程和旅游行程景...
    英语作文，因为生病不能在10月1日去机场接朋友Amy，感谢朋...
    三亚旅游，请问各位大虾有谁知道银泰度假酒店中秋节订房有什么优...
    关于酒店预定数据库的设计~~