Create the ROOMS table using the specification below: Table Name: ROOMS Field Name/ Data Type Size Constraints column name RID Number PRIMARY KEY RType Varchar2 25 NOT NULL Rate Number 5 Bedroom Number 5 Room_Status Varchar2 10 CID Number REFERENCES to CID in Clients Table View the table structure of the ROOMS table. Answer: Add a CHECK constraint on the RATE column in the ROOMS table. Rate must be greater than O only.
Create the ROOMS table using the specification below: Table Name: ROOMS Field Name/ Data Type Size Constraints column name RID Number PRIMARY KEY RType Varchar2 25 NOT NULL Rate Number 5 Bedroom Number 5 Room_Status Varchar2 10 CID Number REFERENCES to CID in Clients Table View the table structure of the ROOMS table. Answer: Add a CHECK constraint on the RATE column in the ROOMS table. Rate must be greater than O only.
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter10: Transaction Management And Concurrency Control
Section: Chapter Questions
Problem 1P
Related questions
Concept explainers
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Question
Transcribed Image Text:Create the ROOMS table using the specification below:
Table Name: ROOMS
Field Name/
Data Type Size
Constraints
column name
RID
Number
8.
PRIMARY KEY
RType
Varchar2
25
NOT NULL
Rate
Number
5
Bedroom
Number
Room_Status
Varchar2
10
CID
Number
REFERENCES to CID in
Clients Table
View the table structure of the ROOMS table.
Answer:
Add a CHECK constraint on the RATE column in the ROOMS table. Rate must be greater than O only.
Transcribed Image Text:Scenario: The owner of Al Musana Hotel would like to have a database tables that will help him manage the clients
and rooms in his building. He wants to record the information about his clients and its occupancy. The hotel has three
different room types which are available for daily rent only.
As the Database Designer, perform the following tasks to help the owner of the hotel:
Create the CLIENTS table using the specification below:
Table Name: CLIENTS
Field Name/ Data Type
column name
Size
Constraints
CID
Number
8
PRIMARY KEY
CName
Varchar2
25
NOT NULL
Validate to accept
Male or Female only
Gender
Varchar2
10
Address
Varchar2
25
Contact
Number
15
Стуре
Varchar2
15
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning