Preview

Assignment 1 CS 275

Satisfactory Essays
Open Document
Open Document
597 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Assignment 1 CS 275
Assignment #1, 11th Edition
Review Question #2)
1) Data C
2) Database Application B
3) Constraint L
4) Repository G
5) Metadata F
6) Data Warehouse M
7) Information A
8) User View J
9) Database Management System K
10) Data Independence H
11) Database E
12) Enterprise Resource Systems Planning I
13) Systems Development Life Cycle R
14) Prototyping O
15) Enterprise Data Model D
16) Conceptual Schema Q
17) Internal Schema P
18) External Schema N
Problems & Exercises:
1) Attached as a photo.

8a) One-to-many
8b) One-to-many
8c) There could be a relationship between the store and the customer.

11) Three additional entities for PVFC are Employee, Supplier, and Shipment. They are all valid because they represent important categories of data about the entities managed by the organization.
20a) The field size for the ProductLineName field in the Product table can range from 1-40 characters. Reason being that the SQL Create Table definition of ProductLineID field is set to 40 characters with a VARCHAR datatype.
20b) The ProductID field is set as NOT NULL. ProductID is required because it is the Primary Key of the table. (Primary Key fields cannot be empty or non existent).
20c) The FOREIGN KEY in the SQL statement reveals that the ProductLineID field in the Product_T table refers back to the ProductLineID primary key, which is stored in the ProductLine_T table.

21a) Sales to Date is calculated by multiplying the price by the quantity.
21b) If you remove “Home Office” from the Criteria Line under ProductLineName, all product lines would show instead of just the Home Office line.

22a) These will be needed: Customer, Payment, Order, Invoice, Order Line, Product.
22b) Customer, Payment, Order, Invoice, Order Line, Product (all entities) will be needed for the SQL query.Assignment #1, 11th Edition
Review Question #2)
1) Data C
2) Database Application B
3) Constraint L
4) Repository G
5) Metadata F
6) Data Warehouse M
7)

You May Also Find These Documents Helpful

  • Powerful Essays

    Music

    • 1176 Words
    • 5 Pages

    | Primary Key – may contain alpha and numeric. You create this, do not use autonumber.…

    • 1176 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    It2640 Week 5 Appendix B

    • 632 Words
    • 3 Pages

    Entities for this database application will include a Customer, Products, Orders, Sales Rep and Shipping table. The attributes for the following tables are as follows:…

    • 632 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    b) You are to clearly mark Primary and Foreign Keys as shown in the sample below:…

    • 1494 Words
    • 19 Pages
    Powerful Essays
  • Satisfactory Essays

    3. Consider a table of data about employees. Which of the following fields are keys? Which one would you choose as the primary key? Employee ID Why? Because it is a unique number assigned to each employee.…

    • 421 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    b) 10 Convert the one table in the previous question to a relational database design. Fill each table in your…

    • 1445 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    Lesson 1

    • 1154 Words
    • 7 Pages

    11. What type of task assists you in storing information about customers, vendors, and employees?…

    • 1154 Words
    • 7 Pages
    Satisfactory Essays
  • Powerful Essays

    Btec

    • 1256 Words
    • 6 Pages

    Deadlines: If you do not meet the deadlines for handing in your assignments you may not have your work marked. This could result in you failing the course unless there are exceptional circumstances which must be explained to your tutor and agreed by the Curriculum Manager. Your work should be returned to you marked within 10 working days…

    • 1256 Words
    • 6 Pages
    Powerful Essays
  • Powerful Essays

    Pt2520 Unit 6

    • 1447 Words
    • 6 Pages

    What is data redundancy, and which characteristics of the file system can lead to it?…

    • 1447 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    Nt1320 Unit 7

    • 2041 Words
    • 9 Pages

    2) Once the users have validated and approved the data model, it is transformed into a ________.…

    • 2041 Words
    • 9 Pages
    Good Essays
  • Best Essays

    Termpaper

    • 4159 Words
    • 22 Pages

    1.Identify the potential sales and department store transactions that can be stored within the database.…

    • 4159 Words
    • 22 Pages
    Best Essays
  • Powerful Essays

    Mkt 500 Week 2 Assignment

    • 924 Words
    • 4 Pages

    Explain how the product could be expanded to a product line, and the depth and breadth of the line.…

    • 924 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Mkt1 Task

    • 1329 Words
    • 6 Pages

    Complete the following table for your product. Add as many rows as necessary for your product.…

    • 1329 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Aci Product

    • 463 Words
    • 2 Pages

    Product line refers to a group of products that are closely related because they function in a similar manner, are sold to the same customer groups, are marketed through the same types of outlets, or fall within given price ranges. ACI Limited Produces 5 lines of products.…

    • 463 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    1. A 'product package' consists of: A. the exterior wrapping B. the shipping container C. a combination of goods and services D. goods if a manufacturing organization E. customer relations if a service organization 2. 12. Business organizations consist of three major functions which, ideally: A. support one another B. are mutually exclusive C. exist independently of each other D. function independently of each other E. do not interface with each other 3. 13. Which of the following is not a type of operations? A. goods production B. storage/transportation C. entertainment D. communication E. all the above involve…

    • 552 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Product Mix Nestle

    • 284 Words
    • 2 Pages

    * Product Line: A product line refers to a number of products that are related and developed by the same manufacturer.…

    • 284 Words
    • 2 Pages
    Satisfactory Essays

Related Topics