DATABASE DESIGN CONCEPTS by kinhac

VIEWS: 380 PAGES: 117

More Info
									DDC                                                                          BCAS


                           ACKNOWLEDGEMENT


I would like to thank my Database Designing Concepts lecture Mr. Erange De Silva for his
innumerable support under standing and encouragement given.




I also express my sincere gratitude to Mr. J.M.Niwas the Director of British College of
Applied Studies-Kandy for providing all facilities to make my course of study a great
success.




And also I would like to thank my parents, all my friends and everyone who helped me to
make this assignment a success.




                                                                              Thank you

                                                                          M.L.M. Irshan




                                                                                Page | 1
M.L.M. Irshan
DDC                                                                            BCAS


                               INTRODUCTION


      VEP Super Centre, an emerging shopping mall in city of Mathara. The business
      focuses on providing services towards customers. The business will also comprise of
      suppliers providing goods for marketing purposes, therefore the managing director of
      the VEP Super Centre requires an Information System in order to make the business
      process more efficient and easy in managing Inventory, Sales, Orders, CRM
      (Customer Relationship Management)

       I made an information system in order to make the business process of VEP super
      centre more efficient and easy and this is the system which I made.




                                                                                 Page | 2
M.L.M. Irshan
DDC                                                                        BCAS


TASK 01


                                          Entities

What is an Entity?
      Some Set of Attributes Are under the Heading. Those Attribute can consider That
Heading as an Entity




What is Attribute?
Which Property is describing the entity, we can call it as an Attribute.




                           Entities of VEP Super Center

   1. Customer
   2. Supplier
   3. Department
   4. Product
   5. Payment
   6. Brand
   7. Section
   8. Invoice
   9. Receipt
   10. Employee
   11. Order
   12. Sales




                                                                             Page | 3
M.L.M. Irshan
DDC                                                                                BCAS


                             Entities and Attributes
01. Customer Entity


          Customer

    # Cus_ID

    * Cus_Type

    * Cus_Name

    * Cus_Points

    0 Cus_Address

    0 Cus_Contact




Cus_ID (Customer ID)
This is the unique ID for each and every Customers



Cus_Type (Customer Type)
From this we can identify the type of customer whether he or she is a registered customer or
not



Cus_Name (Customer Name)
To get the Customer name



Cus_Points (Customer Points)
Customers are getting points for their purchasing. To record that points



Cus_Address (Customer Address)
To inform about new,available products and to send important details to customer



Cus_Contact (Customer Contact Details)
To use in case of emergency




                                                                                    Page | 4
M.L.M. Irshan
DDC                                                                           BCAS


02. Supplier Entity

          Supplier

   # Sup_ID

   # Sup_Brand_ID

   * Sup_Name

   0 Sup_Address

   0 Sup_Contact




Sup_ID (Supplier ID)
This is the unique ID for each and every Suppliers



Sup_Brand_ID (Supplier Brand ID)
From this we can identify from which brand each supplier supply goods and also this is an
unique ID



Sup_Name (Supplier Name)
To get the Supplier name



Sup_Address (Supplier Address)
To inform about available products,What are the needed products and to send important
details to Suppliers



Sup_Contact (Supplier Contact Details)
To use in case of emergency and if VEP Super centre need any products rapidly they can
easily contact the Suppliers and deal with them




                                                                                 Page | 5
M.L.M. Irshan
DDC                                                                       BCAS


03. Department Entity

         Department

    # Dept_ID

    * Dept_Type

    * Dept_Name

    * Dept_Manager




Dept_ID (Department ID)
This is the unique ID for each and every Department



Dept_Type (Department Type)
From this we can identify the type of customer



Dept_Name (Department Name)
To get the Department name



Dept_Manager (Department Manager)
Each and every department has a departmentment Manager, The department is under that
manager’s control.Then it’s easy to handle the process




                                                                            Page | 6
M.L.M. Irshan
DDC                                                                           BCAS


04. Product Entity

           Product

   # Prod_Code

   # Prod_Brand_ID

   * Prod_Name

   * Prod_Description

   * Prod_Section

   * Prod_Cost_Price

   * Prod_Sales_Price

   * Prod_Stock

   * Prod_Reorder_Level

   * Prod_Return_Cond

   0 Prod_Addi_cmnts



Prod_Code (Product Code)
To identify the product uniquely. Unique ID of the Products



Prod_Brand_ID (Product Brand ID)
Sevaral kind of company suppliers are supplying goods to VEP Super centre. So to identify
the brand of the product im using this attribute also this is an unique ID

Ex: -   Kist    ---     BID0001

        MD      ---     BID0002




Prod_Name (Product Name)
To get the name of the product such as,

Ex: -   Book, Shirt, Soap, Hair gel




                                                                                 Page | 7
M.L.M. Irshan
DDC                                                                                   BCAS


Prod_Description (Product Description)
To get a description about product such as

Ex: -   Product Life time

        Warranty period



Prod_Section (Product Section)
This is a super centre. So here we can find several kind of products. If we separate products
in to sections It will be very easier for the management as well as the customers.

Ex: -   Grocery

        Stationary

        Dressing



Prod_Cost_Price(Product Cost Price)
The Cost price of the product



Prod_Sales_Price (Product Sales Price)
The Sales price of the product



Prod_Stock (Product Stock)
Available stock in hand



Prod_Reorder_Level (Poduct Reorder Level)
The reorder level of the product.



Prod_Return_Cond (Product Returning Condition)
The returning condition of product, Can return or cannot, If returnable within how many days
it should be returned. What are the conditions

Ex: -   Shirt ---    Returnable     ---   3days after purchasing   ---   Don’t remove any Labels



Prod_Addi_cmnts(Product Additional Comments)
Some Additional comments about the product.




                                                                                        Page | 8
M.L.M. Irshan
DDC                                                                               BCAS


05. Payment Entity

          Payment

   # Pay_ID

   * Pay_Type

   * Pay_Sub_Total

   * Pay_Discount

   * Pay_Total



Pay_ID (Payment ID)
Customers, Suppliers as well as the Employees of VEP super centre are having a payment
ID So it’s easy to identify and handle every payments. Also this is the unique ID of payments



Pay_Type (Payment Type)
Here we can pay our bill in several types. Such as,

      Cash
      Check
      Credit Card (Visa, Master, Set)

So it’s easy to identify the payment type/Mode



Pay_Sub_Total (Payment Sub Total)
Before we calculate the total we have to deduct the discount from the sub total

Ex: - Rs.5500



Pay_Discount (Payment Discount)
To get discount. VEP super centre is givig discount for each product

Ex: - Rs. 500



Pay_Total (Payment Total)
To get the total amount of sales. (Sub Total – Discount)

Ex: - Rs. 5500 – Rs. 500 =Rs. 5000



                                                                                    Page | 9
M.L.M. Irshan
DDC                                                                               BCAS


06.Brand Entity

               Brand

   # Brand_ID

   # Brand_Sup_ID

   * Brand_Name

   * Brand_Product




Brand_ID (Brand ID)
Same product can be come with many brands. From this we can identify the brand of the
product. And Brand ID is the unique ID of all brands

Ex: -   Kist     ---   BID0001

        MD       ---   BID0002



Brand_Sup_ID (Brand Supplier ID)
From this we can identify which supplier supplies which brand. And this is an unique ID.



Brand_Name (Brand Name)
The Name of the brand



Brand_Product (Brand Product)
The product or products of the each brand




                                                                                   Page | 10
M.L.M. Irshan
DDC                                                                               BCAS


07. Section Entity

           Section

   # Sec_ID

   * Sec_Type

   * Sec_Name




Sec_ID (Section ID)
This is a super centre. So here we can find several kind of products. If we separate products
in to sections It will be very easier for the management as well as the customers.this is the
Unique ID of the section entity

Ex: - SCID0001



Sec_Type (Section Type)
The type of the section

Ex: -   Gents

        Ladies

        Kids



Sec_Name (Section Name)
The name of the section

Ex: -   Grocery

        Stationary

        Dressing




                                                                                   Page | 11
M.L.M. Irshan
DDC                                                                               BCAS


08. Invoice Entity

           Invoice

    # Inv_No

    # Inv_Sup_ID

    * Inv_Date

    * Inv_Sub_Total

    * Inv_Discount

    * Inv_Total




Inv_No (Invoice Number)
To identify the Invoice uniquely. Unique ID of the Invoice

Ex: -   INV0002



Inv_Sup_ID (Invoice supplier ID)
Many suppliers are supplying goods to VEP Super centre. And they are getting invoices.
also this is the unique ID of suppliers.



Inv_Date(Invoice Date)
The date of invoice received or delivered.



Inv_Sub_Total (Invoice Sub Total)
Before we calculate the total we have to deduct the discount from the sub total

Ex: - Rs.5500



Inv_Discount (Invoice Discount)
To get discount.



Inv_Total (Invoice Total)
To get the total amount of sales. (Sub Total – Discount)


                                                                                  Page | 12
M.L.M. Irshan
DDC                                                                        BCAS


09. Receipt Entity

           Receipt

    # Rec_No

    # Rec_Cus_ID

    # Rec_Emp_ID

    # Rec_Pay_ID

    * Rec_Date

    * Rec_Time

    * Rec_Sub_Total

    * Rec_Discount

    * Rec_Total

    * Rec_Points




Rec_No (Receipt Number)
To identify the Receipt uniquely. Unique ID of the Reciept

Ex: -   REC0007



Rec_Cus_ID (Receipt Customer ID)
This is the unique ID of Customers. Many Customers are buying goods from VEP Super
centre. And they are receiving the Receipt.

Ex: -   CID0005



Rec_Emp_ID (Receipt Employee ID)
If we have Employee ID in Receipt we can find which employee issued the receipt. Here
there are many employees but from Employee ID we can find them uniquely.

Ex: -   EID0010



Rec_Pay_ID (Receipt Payment ID)
The payment ID of the customer. An unique ID

Ex: -   PID0013

                                                                            Page | 13
M.L.M. Irshan
DDC                                                                               BCAS


Rec_Date(Receipt Date)
The date of Receipt issued



Rec_Time (Receipt Time)
The time of Receipt issued



Rec_Sub_Total (Receipt Sub Total)
Before we calculate the total we have to deduct the discount from the sub total

Ex: - Rs.5500



Rec_Discount (Receipt Discount)
To get discount

Ex: - Rs. 500



Rec_Total (Receipt Total)
To get the total amount of customer purchase (Sub Total – Discount)

Ex: - Rs. 5500 – Rs. 500 =Rs. 5000



Rec_Points (Receipt Points)
The points which customer earned




                                                                                  Page | 14
M.L.M. Irshan
DDC                                                 BCAS


10. Employee Entity

          Employee

    # Emp_ID

    * Emp_Name

    * Emp_Type

    0 Emp_Address

    0 Emp_Contact




Emp_ID (Employee ID)
This is the unique ID for each and every Employee



Emp_Name (Employee Name)
To get the Employee name



Emp_Type (Employee Type)
From this we can identify the type of Employee,

Ex: -      Cashier

           Cleaner

           Sales



Emp_Address (Employee Address)
To inform important details to employee



Emp_Contact (Employee Contact Details)
To use in case of emergency




                                                    Page | 15
M.L.M. Irshan
DDC                                                                               BCAS


11. Order Entity

                Order

        # Ord_No

        # Ord_Cus_ID

        # Ord_Prod_ID

        * Ord_Cus_Name

        * Ord_Type

        * Ord_Date

        * Ord_Scheme

        0 Ord_Cus_Contact



        0 Emp_Address

        0 Emp_Contact
Ord_No (Order Number)
To identify the Orders uniquely. Unique ID of the Orders

Ex: -    ORD0009



Ord_Cus_ID (Receipt Customer ID)
This is the unique ID of Customers. From this we can identify the customer who made the
order.

Ex: -    CID0005



Ord_Prod_ID (Order Product ID)
Ordered products ID. Then easily can find which product. This is the unique ID of products.

Ex: -    PID0013



Ord_Type (Order Type)
The type of order such as,

Ex: -    Over the counter

         Over the phone



                                                                                   Page | 16
M.L.M. Irshan
DDC                                                                    BCAS




Ord_Date (Order Date)
The date of Ordered



Ord_Scheme (Order Scheme)
The order scheme

Ex: -      Quantity scheme

           Promotional scheme



Ord_Cus_Contact (Order Customer Contact)
The contact details of ordered customer. To use in case of emergency




                                                                       Page | 17
M.L.M. Irshan
DDC                                                                    BCAS


12. Sales Entity


             Sales

   # Sales_ID

   # Sales_Prod_ID

   # Sales_Prod_Brand_ID

   # Sales_Rec_ID

   * Sales_Quantity




Sales_ID (Sales ID)
This is the unique ID of sales



Sales_Prod_ID (Sales Product ID)
The ID of sold product. Unique ID of product



Sales_Prod_Brand_ID (Sales Product Brand ID)
From this we can identify the sold product brand. Unique ID of brand



Sales_Rec_ID (Sales Receipt ID)
The receipt ID which issued for sold product. Unique ID of Receipt



Sales_Quantity (Sales Quantity)
The quantity of sold goods




                                                                       Page | 18
M.L.M. Irshan
DDC                                                                         BCAS


                             Entity Relationship
Customer & Product


         Customer                                                    Product

   # Cus_ID                   May              Must be        # Prod_Code

   * Cus_Type                 Purchase         Purchased by   # Prod_Brand_ID

   * Cus_Name                                                 * Prod_Name

   * Cus_Points                                               * Prod_Description

   0 Cus_Address                                              * Prod_Section

   0 Cus_Contact                                              * Prod_Cost_Price

                                                              * Prod_Sales_Price

                                                              * Prod_Stock
A customer may purchase one or many products                  * Prod_Reorder_Level
A product must be purchase by a customer                      * Prod_Return_Cond

                                                              0 Prod_Addi_cmnts




Customer & Payment


        Customer                                                     Payment

  # Cus_ID                                                    # Pay_ID

  * Cus_Type                   Must            Must be        * Pay_Type

  * Cus_Name                   Pay             Paid           * Pay_Sub_Total

  * Cus_Points                                                * Pay_Discount

  0 Cus_Address                                               * Pay_Total

  0 Cus_Contact



A Customer must pay one or many payments

A payment must be paid by a customer

                                                                             Page | 19
M.L.M. Irshan
DDC                                                                            BCAS


Customer & Receipt



      Customer                                                         Receipt

# Cus_ID                                                         # Rec_No

* Cus_Type                                                       # Rec_Cus_ID
                         Must                          Must be
* Cus_Name                                                       # Rec_Emp_ID
                         Get                           given
* Cus_Points                                                     # Rec_Pay_ID

0 Cus_Address                                                    * Rec_Date

0 Cus_Contact                                                    * Rec_Time

                                                                 * Rec_Sub_Total

                                                                 * Rec_Discount
A customer must get a receipt for purchased products
                                                                 * Rec_Total
A receipt must be given to a customer
                                                                 * Rec_Points




Customer & Order




           Customer                                                     Order

   # Cus_ID                                                      # Ord_No

   * Cus_Type                                                    # Ord_Cus_ID

   * Cus_Name                  May                Must be        # Ord_Prod_ID

   * Cus_Points                Make               made by        * Ord_Cus_Name

   0 Cus_Address                                                 * Ord_Type

   0 Cus_Contact                                                 * Ord_Date

                                                                 * Ord_Scheme

A customer may make one or many orders                           0 Ord_Cus_Contact

A order must be made by a customer

                                                                 0 Emp_Address
                                                                             Page | 20
M.L.M. Irshan                                                    0 Emp_Contact
DDC                                                                      BCAS


Supplier & Product



         Supplier                                              Product

  # Sup_ID                                              # Prod_Code

  # Sup_Brand_ID                                        # Prod_Brand_ID
                           Must              Must be
  * Sup_Name                                            * Prod_Name
                           Supply            Supplied
  0 Sup_Address                                         * Prod_Description

  0 Sup_Contact                                         * Prod_Section

                                                        * Prod_Cost_Price

                                                        * Prod_Sales_Price
A supplier must supply one or many product
                                                        * Prod_Stock
A product must be supplied by a supplier
                                                        * Prod_Reorder_Level

                                                        * Prod_Return_Cond

                                                        0 Prod_Addi_cmnts




Supplier & Payment



        Supplier                                              Payment

  # Sup_ID                                              # Pay_ID
                           Must              May be
  # Sup_Brand_ID                                        * Pay_Type
                           Get               getting
  * Sup_Name                                            * Pay_Sub_Total

  0 Sup_Address                                         * Pay_Discount

  0 Sup_Contact                                         * Pay_Total




A supplier must get one or many payments

A payment may be getting by a customer




                                                                         Page | 21
M.L.M. Irshan
DDC                                                                          BCAS


Supplier & Brand



         Supplier                                                   Brand

  # Sup_ID                                                  # Brand_ID
                                May              May be
  # Sup_Brand_ID                                            # Brand_Sup_ID
                                Supply           supplied
  * Sup_Name                                                * Brand_Name

  0 Sup_Address                                             * Brand_Product

  0 Sup_Contact




A supplier may supply products in one brand

A (product) brand may be supplied by one or many supplier




Supplier & Invoice



         Supplier                                                  Invoice

  # Sup_ID                                                  # Inv_No

  # Sup_Brand_ID                                            # Inv_Sup_ID
                             Must                must be
  * Sup_Name                                                * Inv_Date
                             Get                 given
  0 Sup_Address                                             * Inv_Sub_Total

  0 Sup_Contact                                             * Inv_Discount

                                                            * Inv_Total

A supplier must get one or many invoices

An invoice must be given to a supplier




                                                                              Page | 22
M.L.M. Irshan
DDC                                                                           BCAS


Department & Employee




        Department                                                Employee

   # Dept_ID                                                 # Emp_ID

   * Dept_Type             Must                Must          * Emp_Name

   * Dept_Name             Have                work          * Emp_Type

   * Dept_Manager                                            0 Emp_Address

                                                             0 Emp_Contact



A department must have one or many employees

An employee must work under a department




Product & Brand




        Product                                                    Brand

 # Prod_Code                                                # Brand_ID

 # Prod_Brand_ID                  May          May be       # Brand_Sup_ID

 * Prod_Name                      Have         given        * Brand_Name

 * Prod_Description                                         * Brand_Product

 * Prod_Section

 * Prod_Cost_Price

 * Prod_Sales_Price            A product may have a brand

 * Prod_Stock                  A brand may be given to one or many products

 * Prod_Reorder_Level

 * Prod_Return_Cond

 0 Prod_Addi_cmnts


                                                                              Page | 23
M.L.M. Irshan
DDC                                                                         BCAS


Product & Section

        Product                                                      Section

 # Prod_Code                                                   # Sec_ID
                        Must be                      Must
 # Prod_Brand_ID                                               * Sec_Type
                         Kept                        have
 * Prod_Name                                                   * Sec_Name

 * Prod_Description

 * Prod_Section

 * Prod_Cost_Price
                         A product must be kept in a section
 * Prod_Sales_Price
                         A section must have one or many products
 * Prod_Stock

 * Prod_Reorder_Level

 * Prod_Return_Cond

 0 Prod_Addi_cmnts




Product & Order

       Product                                                        Order

# Prod_Code                                                    # Ord_No

# Prod_Brand_ID                                                # Ord_Cus_ID

* Prod_Name                                                    # Ord_Prod_ID
                          Must be                  Must
* Prod_Description                                             * Ord_Cus_Name
                          Contained                contain
* Prod_Section                                                 * Ord_Type

* Prod_Cost_Price                                              * Ord_Date

* Prod_Sales_Price                                             * Ord_Scheme

* Prod_Stock                                                   0 Ord_Cus_Contact

* Prod_Reorder_Level

* Prod_Return_Cond      A product must be contained in an order0 Emp_Address

0 Prod_Addi_cmnts                                             0 Emp_Contact
                        An order must contain one or many products



                                                                              Page | 24
M.L.M. Irshan
DDC                                                                           BCAS


Product & Sales



                                                                          Sales
         Product
                                                                 # Sales_ID
  # Prod_Code
                                                                 # Sales_Prod_ID
  # Prod_Brand_ID          May be                   Must
                                                                 # Sales_Prod_Brand_ID
  * Prod_Name              Have                     Have
                                                                 # Sales_Rec_ID
  * Prod_Description
                                                                 * Sales_Quantity
  * Prod_Section

  * Prod_Cost_Price

  * Prod_Sales_Price

  * Prod_Stock                A product may be have a sale
  * Prod_Reorder_Level        A sale must have one or many products

  * Prod_Return_Cond

  0 Prod_Addi_cmnts




Receipt & Sales


          Receipt                                                    Sales

   # Rec_No                                                # Sales_ID
                         Must be             Must
   # Rec_Cus_ID                                            # Sales_Prod_ID
                         Issued              Have
   # Rec_Emp_ID                                            # Sales_Prod_Brand_ID

   # Rec_Pay_ID                                            # Sales_Rec_ID

   * Rec_Date                                              * Sales_Quantity

   * Rec_Time
                           A receipt must be issued for a sale
   * Rec_Sub_Total
                           A sale must have a receipt
   * Rec_Discount

   * Rec_Total

   * Rec_Points

                                                                              Page | 25
M.L.M. Irshan
DDC                                                                     BCAS


TASK 02


                           DATA DICTIONARY



Table: Brand

Properties
DateCreated:     7/19/2008 11:50:59 AM                   DefaultView: 2
DisplayViewsOnSharePoint              1                  FilterOnLoad: False
GUID:            {guid {B3AAD8FF-3A04-4198-              HideNewField: False
                 9311-5F3FE18A6D93}}
LastUpdated:     7/19/2008 2:03:44 PM NameMap:           Long binary data
OrderByOn:       False                OrderByOnLoad:     True
Orientation:     Left-to-Right        RecordCount:       3
TotalsRow:       False                Updatable:         True


Columns
       Name                                    Type               Size
       Brand_ID                                Text                      10
             AggregateType:      -1
             AllowZeroLength:    True
             AppendOnly:         False
             Attributes:         Variable Length
             CollatingOrder:     General
             ColumnHidden:       False
             ColumnOrder:        1
             ColumnWidth:        Default
             DataUpdatable:      False
             DisplayControl:     Text Box
             GUID:               {guid {1599E567-9155-4E19-9F16-E667F6870514}}
             IMEMode:            0
             IMESentenceMode: 3
             InputMask:          "BID - "####
             OrdinalPosition:    0
             Required:           False
             SourceField:        Brand_ID
             SourceTable:        Brand
             TextAlign:          General
             UnicodeCompression:         True

       Brand_Sup_ID                           Text                          10
             AggregateType:     -1
             AllowZeroLength:   True
             AppendOnly:        False
             Attributes:        Variable Length
             CollatingOrder:    General
             ColumnHidden:      False
             ColumnOrder:       Default

                                                                            Page | 26
M.L.M. Irshan
DDC                                                                             BCAS


                ColumnWidth:        Default
                DataUpdatable:      False
                DisplayControl:     Text Box
                GUID:               {guid {2CA055EB-1B95-491E-9564-04120A981F35}}
                IMEMode:            0
                IMESentenceMode:    3
                InputMask:          "SID - "####
                OrdinalPosition:    1
                Required:           False
                SourceField:        Brand_Sup_ID

Table: Brand
                SourceTable:        Brand
                TextAlign:          General
                UnicodeCompression:       True

       Brand_Name                                  Text                            10
             AggregateType:         -1
             AllowMultipleValues: False
             AllowValueListEdits: True
             AllowZeroLength:       True
             AppendOnly:            False
             Attributes:            Variable Length
             BoundColumn:           1
             CollatingOrder:        General
             ColumnCount:           1
             ColumnHeads:           False
             ColumnHidden:          False
             ColumnOrder:           Default
             ColumnWidth:           Default
             ColumnWidths:          1440
             DataUpdatable:         False
             DisplayControl:        Combo Box
             GUID:                  {guid {6330185C-D569-4646-8449-A366BBDBBFE7}}
             IMEMode:               0
             IMESentenceMode: 3
             LimitToList:           False
             ListRows:              16
             ListWidth:             1440twip
             OrdinalPosition:       2
             Required:              False
             RowSource:
             "KIBS";"Kist";"Kivi";"Panasonic";"Sony";"Reborn";"Spirit";"Kibs";"Pum
                                    a";"Richard";"Atlas";"Homran";"Prima";"Maggi";"Other"
             RowSourceType:         Value List
             ShowOnlyRowSourceValues:              False
             SourceField:           Brand_Name
             SourceTable:           Brand
             TextAlign:             General
             UnicodeCompression:            True

       Brand_Product                              Text                            15
             AggregateType:         -1
             AllowZeroLength:       True

                                                                                 Page | 27
M.L.M. Irshan
DDC                                                                    BCAS


                AppendOnly:        False
                Attributes:        Variable Length
                CollatingOrder:    General
                ColumnHidden:      False
                ColumnOrder:       Default
                ColumnWidth:       1785
                DataUpdatable:     False
                DisplayControl:    Text Box
                GUID:              {guid {2FFC32DA-8B06-43C6-9727-B0AC767D1A3E}}
                IMEMode:           0
                IMESentenceMode:   3
                OrdinalPosition:   3
                Required:          False
                SourceField:       Brand_Product
                SourceTable:       Brand

Table: Brand
                TextAlign:          General
                UnicodeCompression:       True


Table Indexes
      Name                             Number of Fields
      Brand_ID                         1
             Clustered:            False
             DistinctCount:        6
             Foreign:              False
             IgnoreNulls:          False
             Name:                 Brand_ID
             Primary:              False
             Required:             False
             Unique:               False
             Fields:
             Brand_ID              Ascending
      Brand_Sup_ID                     1
             Clustered:            False
             DistinctCount:        6
             Foreign:              False
             IgnoreNulls:          False
             Name:                 Brand_Sup_ID
             Primary:              False
             Required:             False
             Unique:               False
             Fields:
             Brand_Sup_ID          Ascending
      PrimaryKey                       2
             Clustered:            False
             DistinctCount:        3
             Foreign:              False
             IgnoreNulls:          False
             Name:                 PrimaryKey
             Primary:              True
             Required:             True
             Unique:               True

                                                                        Page | 28
M.L.M. Irshan
DDC                                                                          BCAS


                Fields:
                Brand_ID          Ascending
                Brand_Sup_ID      Ascending



User Permissions
      admin                Delete, Read Permissions, Set Permissions, Change Owner,
Read Definition,
                           Write Definition, Read Data, Insert Data, Update Data, Delete
Data



Group Permissions
      Admins               Delete, Read Permissions, Set Permissions, Change Owner,
Read Definition,
                           Write Definition, Read Data, Insert Data, Update Data, Delete
Data
      Users                Delete, Read Permissions, Set Permissions, Change Owner,
Read Definition,
                           Write Definition, Read Data, Insert Data, Update Data, Delete
Data




Table: Custommer

Properties
DateCreated:     6/21/2008 4:41:16 PM DefaultView:            2
DisplayViewsOnSharePoint              1                       FilterOnLoad: False
GUID:            {guid {A84B2723-D9D8-4DCE-                   HideNewField: False
                 A8E8-CF5D44F1A7E1}}
LastUpdated:     7/19/2008 2:01:56 PM NameMap:                Long binary data
OrderByOn:       False                OrderByOnLoad:          True
Orientation:     Left-to-Right        RecordCount:            3
TotalsRow:       False                Updatable:              True


Columns
       Name                                     Type                  Size
       Custommer_ID                             Text                               8
             AggregateType:       -1
             AllowZeroLength:     True
             AppendOnly:          False
             Attributes:          Variable Length
             CollatingOrder:      General
             ColumnHidden:        False


                                                                                 Page | 29
M.L.M. Irshan
DDC                                                                      BCAS


                ColumnOrder:        Default
                ColumnWidth:        1890
                DataUpdatable:      False
                DisplayControl:     Text Box
                GUID:               {guid {8F5AB05B-5105-412A-BF95-CC3D9C594CFE}}
                IMEMode:            0
                IMESentenceMode: 3
                InputMask:          "CID-"####
                OrdinalPosition:    0
                Required:           False
                SourceField:        Custommer_ID
                SourceTable:        Custommer
                TextAlign:          General
                UnicodeCompression:         False

       Custommer_Type                             Text                      10
             AggregateType:         -1
             AllowMultipleValues:   False
             AllowValueListEdits:   True
             AllowZeroLength:       True
             AppendOnly:            False
             Attributes:            Variable Length
             BoundColumn:           1
             CollatingOrder:        General
             ColumnCount:           1
             ColumnHeads:           False
             ColumnHidden:          False
             ColumnOrder:           Default
             ColumnWidth:           2430
             ColumnWidths:          1440
            
								
To top