Scribd
Upload
8 views2 pages

Food City DBMS Group Assignment Guide

The document provides guidelines for a group assignment on data base management systems. It outlines that groups should have 10 members, submission deadlines, and deliverables including an ER diagram, relational database design in 3NF, developing the database in MySQL, and running queries. The assignment scenario is for an inventory system for a new food store called Star Food City to manage customers, suppliers, products, stock, and billing.

Uploaded by

kavishen1025
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views2 pages

Food City DBMS Group Assignment Guide

The document provides guidelines for a group assignment on data base management systems. It outlines that groups should have 10 members, submission deadlines, and deliverables including an ER diagram, relational database design in 3NF, developing the database in MySQL, and running queries. The assignment scenario is for an inventory system for a new food store called Star Food City to manage customers, suppliers, products, stock, and billing.

Uploaded by

kavishen1025
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

23.

2 Data Base Management Systems(DBMS) - Group Assignment

Guidelines:
• Group members: 10 per group (No Adjustments)
• Assign your group members to the given link in NLearn before submitting
the assignment.
• Submission deadline: 29th Febraury 2024 23.59 pm.
• Deliverables: Add required screenshots to the report (queries to perform the
required tasks). Submit a zip file including the report and the database files, to
the link in NLearn. Only one member should submit the assignment on behalf
of the group.
• The submission file name should be “DB_Lecture goup name_Assignment
group [Link]”. E.g.: “DB_Group A_Group 01”
• Email submissions will not be accepted for any reason.
• Late submissions are accepted for a 30-minute grace period and will get 10%
penalty marks. After that period, the submission link will be closed.

Assignment scenario:
The “Star” Food City wanted to have an Inventory system for their operations to
maintain their stock and billing operations.
Food city is a new initiative and they have only one branch with number of cashier
points. The operations are executed by the managers. The organizations wanted to keep
the Customer, supplier, and product details to manage it.

[Link] an ER diagram to show the entities, attributes, and relationships between


attributes of this scenario.
2. Design the relational database related to this scenario which its tables are in the
3NF (You can display the database schemas for your answer).
3. Develop a database to show the tables identified in question 02 using MySQL.
4. Run MySQL queries to perform the following actions.
a. Add 05 new customers to the database (customer numbers should below 10).
b. Select all customers whose Customer Number is less than 05.
c. Display All customer details.
d. Delete the customer who has not purchased anything within the month.
e. Update the product prices by additional 10% (TAX)
5 Suggest New ideas to run this organization.

(Consider this as Realtime scenario and implement everything by considering the practicality)

You might also like