Nt1330 Unit 2 Assignment

Words: 744
Pages: 3
Open Document
Assignment Activity Unit 2: Database Development for an E-Commerce Platform Lyudmyla Oskolkova University of the People MSIT 5210-01 Databases - AY2024-T4 Dr. Ashish Musale April 24, 2024 Contents Contents 2 Introduction 4 Definition of Entities 4 Relationships Between Entities 4 Attributes. 5 Defining Primary Keys 6 Additional Requirement 7 Final ER Diagram 8 Conceptual and Physical ER Models 8 References 9

Introduction According to the assignment, I am tasked with developing a database for an e-commerce platform. It is assumed that customers can place multiple orders, each order consisting of one or more products. Each product belongs to a specific category. Customers can maintain multiple shipping addresses for their orders. Definition …show more content…
The assignment does not contain a detailed description of the required configuration. However, the following conditions are allowed: Each customer has a name, a list of delivery addresses, and contact information. Each product has a name, price, and is also characterized by units of measurement. Each order has a unique number, date, a list of products with their quantity, prices, and total order amount. An order is made for a specific buyer to a specific delivery address. The price specified in the order may differ from the current price of the product. Each category of goods has its name. Considering the above, the ER diagram takes the following form: Defining Primary Keys Primary keys are vital elements of a holistic database architecture. Primary keys play a key role in establishing relationships between tables using foreign keys (Yasar, 2022). For each entity, I will create a key attribute (Id). Additional Requirement With additional considerations, thoughts appeared that in this database it would be nice to track the delivery of the order and payments made by the client. To implement these ideas, you need to add two entities to the database: Payments and Tracking Details. Thinking about attributes, I concluded that each payment should have an Id, number, date, and amount. Tracking Details must contain the tracking number, carrier name, and delivery status. Here Tracking number and Id will be used as key elements. Additional connections arise between entities: Related Entities Justification for the Mapping Cardinality Type of Cardinality Orders-Tracking Details The Order has one Tracking Detail. Tracking Details describes one order. one-to-one Customers Payments Customers can create many Payments. Orders can be created by one customer. one-to-many Orders-Payments Orders have one Payment. Payment can only be made for one order.
Show More

Related Documents: Nt1330 Unit 2 Assignment

Nt1330 Unit 2 Assignment

(DPCM), scalar quantization and Variable Length Coding (VLC).Version 2 includes the process of motion compensation and background prediction. The operational data rate is 1544-2048 Kbps. Table 1.1 Video coding standards [43] Video standards Organization Data rates Approved year H.120 CCITT 1544-2048 Kbps Approved in 1984,revised in 1988 H.261 ITU-T 64-2048 Kbps Approved in 1991,revised in 1993 MPEG-1 MPEG 1-2 Mbps Approved in 1993 MPEG-2 MPEG 4-30 Mbps Approved in 1995 H.263 ITU-T 10-2048 Kbps Approved…

Words 414 - Pages 2

Nt1330 Unit 2 Assignment

Overview Statement: What is the role of It’s best to sleep on your back in a slightly elevated position for at least two weeks after lipo 360 surgery. Some patients can comfortably and safely transition to side sleeping after the initial two weeks. Avoid sleeping on your stomach while healing from lipo 360. H2: General Best Practices. Sleeping after surgery can be difficult, and doing so after a lipo 360 procedure can present some challenges since the surgery affects your front, back, and…

Words 526 - Pages 3

Nt1330 Unit 2 Assignment 2

CSC2101Information Technologyfor Business 2 Assignment 2: The IT Security TEE WEN JIE DBM/0417/004 1.What is Data security and Information security? Data security is the precaution of unauthorized access, use, disruption, modification or destruction of stored data. Information security is the precaution of unauthorized access, use, disruption, modification or destruction about information. Data security is particularly to data in storage. Information security is a more extensive practice…

Words 759 - Pages 4

Nt1330 Unit 3 Assignment 2

I can help benefit the server by being a staff member by always monitoring chat while I am on to see if anybody needs help. Also if someone reports a player I would go check that player out, record him, and if I think he is suspicious freeze him and ask him to join the HCGames Ts so I can screen share him or her and look for any unfair advantage he or she might have. Also if a new player were to join the server and was confused about how the server works or had any questions about the server I would…

Words 651 - Pages 3

Nt1330 Unit 3 Assignment 2

6. Describe a topic, idea, or concept you find so engaging that it makes you lose all track of time. Why does it captivate you? What or who do you turn to when you want to learn more? 7 paragraph, 7 sentence per-paragraph essay Ever since I was a child I loved to take things apart. I liked to take them apart to see if I could understand what makes them work the way that they do. My parents would buy things like like legos and put together landscapes for toy trains to chugg around. I would…

Words 1028 - Pages 5

Nt1330 Unit 2 Individual Assignment

Overall Experience I interned at Avalon Software Consulting for 5 months during the Fall of 2015, from early August until the end of December. Founded in 2005, Avalon Software Consulting is a rapidly growing consulting company with focus to deliver laboratory quality management software to textile manufacturing companies in Florida. I became familiar with Avalon Software Consulting through the email that Karen Brown sent to the department mailing forum about the internship opportunity. The internship…

Words 1624 - Pages 7

Nt1330 Unit 2 Individual Assignment

sales. Essential fields for GST Invoice Generally a tax invoice or bill is issued for charging the tax and passing it on the input tax credit. A GST Invoice should have the following mandatory fields. Take a look at them. 1. Invoice Number and Date 2. Name of the customer 3. Customer and taxpayer GSTIN 4. Shipping and Billing Address 5. Details of the item. 6. Taxable discounts 7. Signature of the GST Supplier. 8. Place of Supply…

Words 497 - Pages 2

Nt1330 Unit 2 Individual Assignment

The world is becoming smaller and smaller with each new technological invention and globalization, effecting migration, food production, climate change and our own personal views of the world around us. We find ourselves faced with a wide spectrum of human and environmental issues, stretching from the local to the global, the individual consumer to a multi-national corporation, and it is there, in the in - between, where the skills of an anthropologists are vital. As an anthropologist, I am capable…

Words 465 - Pages 2

Nt1330 Unit 3 Assignment 2

Assignment # 2 For this assignment I decided to reach out to an AT&T retail store manager Rodney Owens. Rodney currently manages one of the largest AT&T stores in the state of Texas. Rodney invited me to do an inventory count with their inventory manager Natalie Garza to get a first hand look at AT&T’s inventory system Opus Mobile. Opus Mobile uses a manual count that once inputted into the system compares the data of what should be in inventory vs what is missing or in some cases overages. Natalie…

Words 1061 - Pages 5

Nt1330 Unit 2 Assignment 2 Employee Analysis

If I were Kelly I would call the employee to my office, so we can have privacy and the whole office does not hear what I am about to say to the employee. I would start off pointing out the good qualities of my employee and let them know what they do well. I would keep it short and simple. I would tell the employee I appreciate her efforts in our office and how well she does perform. I will remind her about the training she has when dealing with our customers/clients. I would also let her know that…

Words 255 - Pages 2