Task 1: Test your knowledge on database concepts Please answer the following questions: 1.1 Define what...

Transcribed Image Text:

Task 1: Test your knowledge on database concepts Please answer the following questions: 1.1 Define what a primary key is in a database table. State why it is important Individual activity 1.2 Mention some basic database functions that a spreadsheet cannot perform but that can be found in a database. (2) 1.3 Write down the difference(s) between an entity and an attribute. (1) 2.1 (2) Task 2: Create an ERD Individual activity Shein is a popular online clothes retailer with an extensive selection of stylish clothing, accessories, and footwear for men, women, and kids. Customers can browse through and buy the newest fashions at reasonable prices from the comfort of their homes. (Total = 5) Interpret the enterprise/business rule from the following passage and answer the question that follows. 2.2 Write down the database schema entry for the order entity. A database should be created, and the following information should be saved. Firstly, they would like to have a record of all their customers. Customer details include a customer ID, name, contact name, contact title, physical address, city, region, postal code, country, and phone number. Customers should make at least one order but over time will have many orders. An order should belong to a single customer. Order information includes order number, date, date, shipping date, shipping company, and item total. Each order should contain one or more products and products should form part of many orders. Product information includes product code, name, category name, quantity per unit, and unit price. Company policy states that products should be supplied by only one supplier; however, a supplier may supply multiple products. Occasionally it happens that a supplier is listed in the database but that they have no product(s) to supply. Supplier information includes company code, name, physical address, city, region, postal code, country, phone number and website address. Develop an ERD diagram and the database schema based on the above Scenario. Ensure that you indicate the cardinality as well as optionality for each entity identified. (10) (5) (Total = 15) TOTAL = 20 Task 1: Test your knowledge on database concepts Please answer the following questions: 1.1 Define what a primary key is in a database table. State why it is important Individual activity 1.2 Mention some basic database functions that a spreadsheet cannot perform but that can be found in a database. (2) 1.3 Write down the difference(s) between an entity and an attribute. (1) 2.1 (2) Task 2: Create an ERD Individual activity Shein is a popular online clothes retailer with an extensive selection of stylish clothing, accessories, and footwear for men, women, and kids. Customers can browse through and buy the newest fashions at reasonable prices from the comfort of their homes. (Total = 5) Interpret the enterprise/business rule from the following passage and answer the question that follows. 2.2 Write down the database schema entry for the order entity. A database should be created, and the following information should be saved. Firstly, they would like to have a record of all their customers. Customer details include a customer ID, name, contact name, contact title, physical address, city, region, postal code, country, and phone number. Customers should make at least one order but over time will have many orders. An order should belong to a single customer. Order information includes order number, date, date, shipping date, shipping company, and item total. Each order should contain one or more products and products should form part of many orders. Product information includes product code, name, category name, quantity per unit, and unit price. Company policy states that products should be supplied by only one supplier; however, a supplier may supply multiple products. Occasionally it happens that a supplier is listed in the database but that they have no product(s) to supply. Supplier information includes company code, name, physical address, city, region, postal code, country, phone number and website address. Develop an ERD diagram and the database schema based on the above Scenario. Ensure that you indicate the cardinality as well as optionality for each entity identified. (10) (5) (Total = 15) TOTAL = 20 Task 1: Test your knowledge on database concepts Please answer the following questions: 1.1 Define what a primary key is in a database table. State why it is important Individual activity 1.2 Mention some basic database functions that a spreadsheet cannot perform but that can be found in a database. (2) 1.3 Write down the difference(s) between an entity and an attribute. (1) 2.1 (2) Task 2: Create an ERD Individual activity Shein is a popular online clothes retailer with an extensive selection of stylish clothing, accessories, and footwear for men, women, and kids. Customers can browse through and buy the newest fashions at reasonable prices from the comfort of their homes. (Total = 5) Interpret the enterprise/business rule from the following passage and answer the question that follows. 2.2 Write down the database schema entry for the order entity. A database should be created, and the following information should be saved. Firstly, they would like to have a record of all their customers. Customer details include a customer ID, name, contact name, contact title, physical address, city, region, postal code, country, and phone number. Customers should make at least one order but over time will have many orders. An order should belong to a single customer. Order information includes order number, date, date, shipping date, shipping company, and item total. Each order should contain one or more products and products should form part of many orders. Product information includes product code, name, category name, quantity per unit, and unit price. Company policy states that products should be supplied by only one supplier; however, a supplier may supply multiple products. Occasionally it happens that a supplier is listed in the database but that they have no product(s) to supply. Supplier information includes company code, name, physical address, city, region, postal code, country, phone number and website address. Develop an ERD diagram and the database schema based on the above Scenario. Ensure that you indicate the cardinality as well as optionality for each entity identified. (10) (5) (Total = 15) TOTAL = 20 Task 1: Test your knowledge on database concepts Please answer the following questions: 1.1 Define what a primary key is in a database table. State why it is important Individual activity 1.2 Mention some basic database functions that a spreadsheet cannot perform but that can be found in a database. (2) 1.3 Write down the difference(s) between an entity and an attribute. (1) 2.1 (2) Task 2: Create an ERD Individual activity Shein is a popular online clothes retailer with an extensive selection of stylish clothing, accessories, and footwear for men, women, and kids. Customers can browse through and buy the newest fashions at reasonable prices from the comfort of their homes. (Total = 5) Interpret the enterprise/business rule from the following passage and answer the question that follows. 2.2 Write down the database schema entry for the order entity. A database should be created, and the following information should be saved. Firstly, they would like to have a record of all their customers. Customer details include a customer ID, name, contact name, contact title, physical address, city, region, postal code, country, and phone number. Customers should make at least one order but over time will have many orders. An order should belong to a single customer. Order information includes order number, date, date, shipping date, shipping company, and item total. Each order should contain one or more products and products should form part of many orders. Product information includes product code, name, category name, quantity per unit, and unit price. Company policy states that products should be supplied by only one supplier; however, a supplier may supply multiple products. Occasionally it happens that a supplier is listed in the database but that they have no product(s) to supply. Supplier information includes company code, name, physical address, city, region, postal code, country, phone number and website address. Develop an ERD diagram and the database schema based on the above Scenario. Ensure that you indicate the cardinality as well as optionality for each entity identified. (10) (5) (Total = 15) TOTAL = 20

Answer rating: 100% (QA)

Task 1 Test your knowledge on database concepts 11 Define what a primary key is in a database table State why it is important Primary Key In a database table a primary key is a unique identifier for e... View the full answer