Create a 3NF Data Model for a department store. Include information for sales, inventory, employees, orders,...
Create a 3NF Data Model for a department store. Include information for sales, inventory, employees, orders, customers. Make sure each one has at least 5 attributes.
Homework Answers
Please find the 3NF database for the department store below.
Customer (CustomerID, FirstName, LastName, Age, Email, Revenue)
Employee (EmployeeID, FirstName, LastName, Age, Salary, Address)
Orders (OrderID, OrderDate, CustomerID, ShippingDate, DeliveryDate, SaleID)
Sales (SaleID, EmployeeID, ProductID, QuantityPlaced, DiscountPercentage, CommissionRate)
Product (ProductID, Name, Description, QuantityInHand, UnitPrice)
** The underlined columns represents primary key of the table
** The bold columns represent foreign key constraint.
Add Answer to:
Create a 3NF Data Model for a department store. Include
information for sales, inventory, employees, orders,...
You are asked to design a data model for The Wagging Tail, an online store that...
You are asked to design a data model for The Wagging Tail, an online store that sells products for dogs, e.g. dog collars, dog food, dog toys, dog treats, etc. You want to keep track of three entities: (1) the products that the store sells, (2) customers who purchase the products, and (3) the orders that are made on the website. Draw an ERD diagram and use the following information to help guide your drawing: The database should keep track...
CREATE an ER diagram for Home Depot. You should have a notion for products (models, features,...
CREATE an ER diagram for Home Depot. You should have a notion for products (models, features, serial number, description, etc …), suppliers, warehouses, contractors, employees, managers and anything else that you believe Home Depot would need to use to run their business. Be detailed! You MUST specify multiplicities -> many-many, many-one, one-one Be sure to specify keys Our database should be able to model the following data: Employees – come up with pertinent data to store for an employee based...
A company database needs to store information about employees
A company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes) Employees work in departments; each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information...
6. Create a typical family relationship-spouse, father, and mother-in a single 3NF relation. Include Name and Date of Birth as non-key attributes. Assume that each family member has only one spou...
6. Create a typical family relationship-spouse, father, and mother-in a single 3NF relation. Include Name and Date of Birth as non-key attributes. Assume that each family member has only one spouse, one father, and one mother. Show foreign keys with dashed undedine, and Primary keys with solid underline. (Come up with your own field names). (3 points)
6. Create a typical family relationship-spouse, father, and mother-in a single 3NF relation. Include Name and Date of Birth as non-key attributes. Assume...
reate a 3NF entity relationship data model based on the scenario presented below Read the following...
reate a 3NF entity relationship data model based on the scenario presented below Read the following paragraph and create a data model for the business under discussion. “My partner and I own an independent record store. Well, I guess record store is really the wrong term these days since we really don’t sell a lot of records anymore. We sell mostly CDs, but also some tapes. And yes, we do stock vinyl records, too. Regardless of format (that is, CD,...
Assignment 3.2 - Data Modeling in Action Develop a conceptual and logical model for a book...
Assignment 3.2 - Data Modeling in Action Develop a conceptual and logical model for a book tracking system with the following requirements: Use Microsoft Visio (available on the Sullivan VDI – https://desktop.sullivan.edu) or Lucidchart Create a conceptual data model Create a logical data model The data model is about a book tracking system with the following objects: Book Publisher Author Store Relationships: A book can have one or many publisher A book can have one or many author A book...
Create an RDM that has entities, Customers, Products, Orders, Payments, and OrderDetails using MS ACCESS. For...
Create an RDM that has entities, Customers, Products, Orders, Payments, and OrderDetails using MS ACCESS. For each entity use the appropriate attributes and explain the relationship being used. (Add as much attributes that reflect on the real world) RDM = relational database model
You are the owner of a small chain of bookstores. To catalog your inventory, create a...
You are the owner of a small chain of bookstores. To catalog your inventory, create a list of at least 25 books using an Excel table. Include the title, author, category and price. Choose one of the available table formats. When finished adding books, sort your list by category. Add relevant WordArt to your worksheet. Name this worksheet “Inventory”. Save your workbook with the name: Odd_Books_ltd.xls. Add a new worksheet that lists total sales by store for each quarter. Include...
Write an SQL CREATE statement to create the structure of a table to store the following...
Write an SQL CREATE statement to create the structure of a table to store the following employee information empLastName, empFirstName, Dept (foreign key to department table), emp Address, empZip, empCity, empState. Use appropriate data types to reflect the data which will be stored in each attribute. Identify attributes which should not be null by using the correct SQL statements in the create statement
6. Create a typical family relationship-spouse, father, and mother-in a single 3NF relation. Include Name and Date of Birth as non-key attributes. Assume that each family member has only one spouse, one father, and one mother. Show foreign keys with dashed undedine, and Primary keys with solid underline. (Come up with your own field names). (3 points)
6. Create a typical family relationship-spouse, father, and mother-in a single 3NF relation. Include Name and Date of Birth as non-key attributes. Assume...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago