| 澶辨晥閾炬帴澶勭悊 |
|
SQL Queries For Beginners PDF 涓嬭澆
鏈珯鏁寸悊涓嬭澆錛?/strong>
閾炬帴錛?a target="_blank">https://pan.baidu.com/s/1F8mRLlmGkHA7mGjBV8I2CA
鎻愬彇鐮侊細9wbz
鐩稿叧鎴浘錛?/strong>
涓昏鍐呭錛?/strong>
Before we start we will first create a table and insert some sample data into it so we can use these
tables in our select class. I want to explain the table design with actual data since that will help
the reader to understand this in detail.
In database design the important phase is to create a table with proper normalization with
primary and foreign key relationships.
Now in this example we will assume we need to create a restaurant Order Management tables
with relationships.
For this we need an Order Master, an Order Detail and an Item Master as the major tables. We
will use these 3 tables in this article. First let's start by creating the tables. As I have said, we will
use the 3 tables here in this article so we start by creating the Item Master as the first table. As
the name suggests this table will be used to store the items.
Create Table
Item Master: Here we have created an ItemMaster with the necessary fields. As I already said,
we need to make a plan about our project. List all the necessary tables we need to create for the
project and describe and list all the fields to be created for each table. Here I used Item_Code as
a primary key field that will be used in another table for the reference to this main table.
1. CREATE TABLE [dbo].[ItemMasters](
2. [Item_Code] [varchar](20) NOT NULL,
3. [Item_Name] [varchar](100) NOT NULL,
4. [Price] Int NOT NULL,
5. [TAX1] Int NOT NULL,
6. [Discount] Int NOT NULL,
7. [Description] [varchar](200) NOT NULL,
8. [IN_DATE] [datetime] NOT NULL,
9. [IN_USR_ID] [varchar](20) NOT NULL,
10. [UP_DATE] [datetime] NOT NULL,
11. [UP_USR_ID] [varchar](20) NOT NULL,
12. CONSTRAINT [PK_ItemMasters] PRIMARY KEY CLUSTERED
13. (
14. [Item_Code] ASC
15. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW
_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
16. ) ON [PRIMARY]
|
| Java1234瀹樻柟緹?5錛?/td> | 
|
| Java1234瀹樻柟緹?5錛?/td> | 838462530 |
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
