Who can help me design a database table of hotel reservations? Send 20 points. Thank you.

-

Create table [dbo]. [Room Type] (

[pk] [int] IDENTITY( 1, 1) is not empty.

[r_type_num] [varchar](50) is not empty.

[room_type] [varchar](50) is not empty.

[bed] [int] is not empty.

[Price] [Floating] is not empty.

[foregift] [float] is not empty.

[cl_room] [varchar](50) NOT NULL constraint [df _ rommtype _ cl _ room] default ('n'),

[cl_price] [float] NULL，

[remarks] [varchar](50) NULL,

[sysmark] [int] NOT NULL constraint [DF_rommtype_sysmark] DEFAULT (0),

[delmark] [int] NOT NULL constraint [DF_rommtype_delmark] DEFAULT (0),

[other 1][varchar](50)NULL，

[other2] [varchar](50) NULL，

Constraint [PK_rommtype] primary key aggregation

(

[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] is unique and 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 [main]

go to

Set ANSI_PADDING to OFF.

go to

Execsys.sp _ addextendedproperty @ name = n' ms _ description', @ value = n' primary key', @ level0type = n' schema', @ level0name = n' dbo', @ level 1type = n' table '，@level 1name=N'roomtype '，@level2type=N'COLUMN '，@level2name=N'pk '

go to

Execsys.sp _ addextendedproperty @ name = n' ms _ description', @ value = n' room abbreviation', @ level0type = n' schema', @ level0name = n' dbo', @ level 1type = n' table '，@level 1name=N'roomtype '，@level2type=N'COLUMN '，@level2name=N'r_type_num '

go to

Execsys.sp _ addextended property @ name = n' ms _ description', @ value = n' room type', @ level0type = n' architecture', @ level0name = n' dbo', @ level 1type = n' table', @level 1name=N' room type', @level2type=N' column', @level2name=N' room type'

go to

Execsys.sp _ addextendedproperty @ name = n' ms _ description', @ value = n' number of beds', @ level0type = n' architecture', @ level0name = n' dbo', @ level 1type = n' table', @level 1name=N' room type', @level2type=N' column', @level2name=N' bed'

go to

Execsys.sp _ addextendedproperty @ name = n' ms _ description', @ value = n' unit price', @ level0type = n' architecture', @ level0name = n' dbo', @ level 1type = n' table', @level 1name=N' room type', @level2type=N' column', @level2name=N' price'

go to

execsys . sp _ add extended property @ name = N ' ms _ description '，@ value = n' deposit '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'roomtype '，@level2type=N'COLUMN '，@level2name=N'foregift '

go to

Execsys.sp _ addextendedproperty @ name = n' ms _ description', @ value = n' Is it a hourly room', @ level0type = n' schema', @ level0name = n' dbo', @ level 1type = n' table '，@level 1name=N'roomtype '，@level2type=N'COLUMN '，@level2name=N'cl_room '

go to

Execsys.sp _ addextendedproperty @ name = n' ms _ description', @ value = n' hourly room rate', @ level0type = n' schema', @ level0name = n' dbo', @ level 1type = n' table '，@level 1name=N'roomtype '，@level2type=N'COLUMN '，@level2name=N'cl_price '

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = n' remarks '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'roomtype '，@level2type=N'COLUMN '，@ level2name = N 'remark '

go to

Execsys.sp _ addextendedproperty @ name = n' ms _ description', @ value = n' system level logo', @ level0type = n' architecture', @ level0name = n' dbo', @ level 1type = n' table', @level 1name=N' room type', @level2type=N' column', @level2name=N' system tag'

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = n' delete flag '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'roomtype '，@level2type=N'COLUMN '，@level2name=N'delmark '

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = n' other 1 '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'roomtype '，@level2type=N'COLUMN '，@level2name=N'other 1 '

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = n' other2 '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'roomtype '，@level2type=N'COLUMN '，@level2name=N'other2 '

go to

/* * * * * Object: table [dbo]. [Destination] Script Date: 05/25/201215: 56: 02 * * */

Set ANSI_NULLS to ON.

go to

SET QUOTED_IDENTIFIER ON

go to

Set ANSI_PADDING to ON.

go to

Create table [dbo]. [doomed] (

[pk] [int] IDENTITY( 1, 1) is not empty.

[client name] [varchar](50) is not empty.

[client_tel] [varchar](50) is not empty.

[room_type_id] [varchar](50) is not empty.

[room_no] [varchar](50) is not empty.

[main _ room] [varchar] (50) is not empty.

[pa_time] [datetime] is not empty.

[keep_time] [datetime] is not empty.

[eng_time] [varchar](50) is not empty.

[remarks] [varchar](50) NULL,

[engagemark] [int] NOT NULL constraint [df _ destination _ engagemark] default (0),

[cluemark] [int] NOT NULL constraint [df _ destination _ cluemark] default (0),

[delmark] [int] NOT NULL constraint [df _ destination _ delmark] default (0),

[other 1][varchar](50)NULL，

[other2] [varchar](50) NULL，

Constraint [PK _ destination] primary key aggregation

(

[pk] ASC

)WITH (PAD_INDEX = OFF，STATISTICS_NORECOMPUTE = OFF，IGNORE_DUP_KEY = OFF，ALLOW_ROW_LOCKS = ON，ALLOW _ PAGE _ LOCKS = ON)ON[PRIMARY]

) on [main]

go to

Set ANSI_PADDING to OFF.

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = n' customer name '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'destine '，@level2type=N'COLUMN '，@level2name=N'client_name '

go to

Execsys.sp _ addextendedproperty @ name = n' ms _ description', @ value = n' customer phone', @ level0type = n' architecture', @ level0name = n' dbo', @ level 1type = n' table', @level 1name=N' destination', @level2type=N' column', @level2name=N'client_tel'

go to

execsys . sp _ add extended property @ name = N ' ms _ description '，@ value = n' room type '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'destine '，@level2type=N'COLUMN '，@level2name=N'room_type_id '

go to

execsys . sp _ add extended property @ name = N ' ms _ description '，@ value = n' room number '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'destine '，@level2type=N'COLUMN '，@level2name=N'room_no '

go to

Execsys.sp _ addextendedproperty @ name = n' ms _ description', @ value = n' main room number', @ level0type = n' schema', @ level0name = n' dbo', @ level 1type = n' table '，@level 1name=N'destine '，@level2type=N'COLUMN '，@level2name=N'main_roomnum '

go to

Execsys.sp _ addextendedproperty @ name = n' ms _ description', @ value = n' arrival time', @ level0type = n' schema', @ level0name = n' dbo', @ level 1type = n' table '，@level 1name=N'destine '，@level2type=N'COLUMN '，@level2name=N'pa_time '

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = n' retention time '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'destine '，@level2type=N'COLUMN '，@level2name=N'keep_time '

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = N ' schema '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'destine '，@level2type=N'COLUMN '，@level2name=N'eng_time '

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = n' remarks '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'destine '，@level2type=N'COLUMN '，@ level2name = N 'remark '

go to

Execsys.sp _ addextendedproperty @ name = n' ms _ description', @ value = n' predetermined state', @ level0type = n' schema', @ level0name = n' dbo', @ level 1type = n' table '，@ level 1 name = N ' destination '，@level2type=N'COLUMN '，@level2name=N'engagemark '

go to

Execsys.sp _ addextendedproperty @ name = n' ms _ description', @ value = n' reminder tag', @ level0type = n' schema', @ level0name = n' dbo', @ level 1type = n' table '，@level 1name=N'destine '，@level2type=N'COLUMN '，@level2name=N'cluemark '

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = n' delete tag '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'destine '，@level2type=N'COLUMN '，@level2name=N'delmark '

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = n' other 1 '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'destine '，@level2type=N'COLUMN '，@level2name=N'other 1 '

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = n' other2 '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'destine '，@level2type=N'COLUMN '，@level2name=N'other2 '

go to

/* * * * * Object: table [dbo]. [User Administrator] Script Date: 05/25/201215: 56: 02 * * * *

Set ANSI_NULLS to ON.

go to

SET QUOTED_IDENTIFIER ON

go to

Set ANSI_PADDING to ON.

go to

Create table [dbo]. [User Administrator] (

[pk] [int] IDENTITY( 1, 1) is not empty.

[userid] [varchar](50) is not empty.

[pwd] [varchar](50) is not empty.

[puis] [int] is not empty.

[delmark] [int] NOT NULL constraint [DF_user_delmark] DEFAULT (0),

[other 1][varchar](50)NULL，

[other2] [varchar](50) NULL，

Constraint [PK_user] primary key aggregation

(

[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] is unique and nonclustered.

(

[User ID] ASC

)WITH (PAD_INDEX = OFF，STATISTICS_NORECOMPUTE = OFF，IGNORE_DUP_KEY = OFF，ALLOW_ROW_LOCKS = ON，ALLOW _ PAGE _ LOCKS = ON)ON[PRIMARY]

) on [main]

go to

Set ANSI_PADDING to OFF.

go to

Execsys.sp _ addextendedproperty @ name = n' ms _ description', @ value = n' user login id', @ level0type = n' schema', @ level0name = n' dbo', @ level 1type = n' table '，@level 1name=N'useradmin '，@level2type=N'COLUMN '，@level2name=N'userid '

go to

Execsys.sp _ addextendedproperty @ name = n' ms _ description', @ value = n' user login password', @ level0type = n' schema', @ level0name = n' dbo', @ level 1type = n' table '，@level 1name=N'useradmin '，@level2type=N'COLUMN '，@level2name=N'pwd '

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = n' user rights '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'useradmin '，@level2type=N'COLUMN '，@level2name=N'puis '

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = n' delete tag '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'useradmin '，@level2type=N'COLUMN '，@level2name=N'delmark '

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = n' other 1 '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'useradmin '，@level2type=N'COLUMN '，@level2name=N'other 1 '

go to

execsys . sp _ addextendedproperty @ name = N ' ms _ description '，@ value = n' other2 '，@ level0type = n' schema '，@ level0name = n' dbo '， @ level 1type = n' table '，@level 1name=N'useradmin '，@level2type=N'COLUMN '，@level2name=N'other2 '

go to

-

If necessary, you can add Baidu HI for details and support it remotely.