CXD1203: DATABASES 1 Assignment, SC, Malaysia Consider the following set of requirements for a worldwide package delivery database that is used to keep track of couriers who ship parcels
University | Sunway College (SC) |
Subject | CXD1203: DATABASES 1 |
This project will be done in a group of a maximum of THREE (3) students.
Consider the following set of requirements for a worldwide package delivery
database that is used to keep track of couriers who ship parcels and customers who receive parcels.
Each parcel must be identifiable and trackable, so the database must be able
to store the parcel tracking number, and its history of locations. The database
must also record the weight of the parcel, and the name, email and phone
number of sender. Each sender sends one or more parcels.
A courier must deliver at least 50 parcels a day. Each parcel is delivered by one
and only one courier. Each courier has unique employee id, name, salary, position, phone numbers, address and email.
Each parcel is shipped to a recipient. The sender must provide complete and
accurate recipient information to the courier company that includes recipient
name, phone number, and address. The complete address must include city,
state, and postcode.
A recipient may receive one or more parcels at the same time. The time and date of the delivery, and the name of the recipient will be recorded when the parcel is delivered to the recipient successfully.
i. Draw the ER diagram. Identify the relationships between entities. You can
make logical assumptions with concrete justifications.
ii. Design the database based on the information given and your own
creativity. Identify the suitable data types, primary key(s) and foreign key(s)
for tables created based on the case study above. Screenshot your
database structure and all relevant SQL queries.
iii. Insert sample data into the tables in package delivery database.
iv. Create TWO inner join queries to retrieve data from multiple tables
Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.
Get Help By Expert
Seeking an Assignment Expert in Malaysia? Look no further! Assignment Helper MY offers top-notch "Do My Assignment" services for Sunway College (SC) students. Get professional assistance with CXD1203: DATABASES 1 Assignment and ensure excellent grades. Our team of experienced writers is dedicated to delivering high-quality solutions tailored to your requirements. Don't let assignments stress you out; entrust them to our reliable service and excel in your academic journey. Visit Assignment Helper MY today and experience the difference.
Recent Solved Questions
- MPU3192: Anda dikehendaki melaporkan pengalaman penemuan anda dalam bentuk refleksi: Falsafah Dan Isu Semasa 2, Assignment, OUM, Malaysia
- Biomechanics Assignment, UOC, Malaysia We expect that you will remember what you learn from writing this paper long after the class is over
- You are planning for your financial retirement. You want to retire at 60. You plan to have an endowment fund that will give you a monthly income of RM 10,000 per month after retirement: Financial Management Assignment, UTP, Malaysia
- TAX467: Saifullah is the owner of Sinar Indah Shop, an electronic shop in Kuala Terengganu since 2004: Taxation Assignment, UiTM, Malaysia
- BUSINESS INFORMATION SYSTEMS Report, UCSI, Malaysia Explain the overall process of developing a new software application based on the latest literature
- Online Order Management System Assignment, APU, Malaysia
- ONM 4202: As a global logistics management consultant, analyse the challenges faced by XYZ Electronics in optimizing: Individual Assignment, IIU, Malaysia
- ABCC1103: Reflect on a significant moment in your life that notably influenced your identity: Introduction To Communication, Assignment, OUM, Malaysia
- Renal Nursing Assignment, MU, Malaysia Discuss the contributing factors to non-adherence to treatment and dietary restrictions among ESKD patients
- BBM207: Human Resource Management Assignment, WOU, Malaysia Describe how the new wage will benefit employees in the urban areas and Discuss the consequences to the economy of Malaysia