Design your own database system for a grocery store

Assignment Help Computer Engineering

Reference no: EM133218585

PART 1:

Design your own database system for a grocery store that takes care of inventory, supply, sale, and basic accounting.

Describe every stage of design, from requirement analysis, business rule generation, big table creation which results in the overall table for 1st NF, and up to 3rd NF normalization.

Detailed description on each stage
Draw ERD with either Chen's diagram or crow foot diagram.
Draw dependency diagrams for normalization
For design portion, you can also name your own database with following minimum requirements:

- At least 4 different tables

- At least 5 syntactically correct records in each table.

- No table can be orphan table, i.e. each table should have at least one relationship with other table(s).

- All tables should be 3NF.

PART 2: Using SQL and the database created in PART 1:

Implement the database you created for PART 1 with SQL, to do the following:

SQL for table definition
SQL for data entering
SQL for frequently used queries
At least one join using FROM clause
At least one using WHERE clause
At least one using HAVING clause
At least one trigger

Reference no: EM133218585

Questions Cloud

Describe purpose of applying nursing theory to patient care : Describe the purpose of applying nursing theory to patient care. Explain why nursing theory is meaningful to current practice

What would be united states department of agriculture animal : In terms of physical resources, what would be the United States Department of Agriculture's Animal and Plant Health Inspection Service's most crucial asset.

Prepare a public service announcement : Prepare a public service announcement Powerpoint targeting senior citizens and the dangers of phishing and smishing attacks. The video should include the social

What person is failed to meet their responsibilities : Research & Summaries Essay - Identify what person or agency is failed to meet their responsibilities in assuring safety for those who died

Design your own database system for a grocery store : Describe every stage of design, from requirement analysis, business rule generation, big table creation which results in the overall table for 1st NF, and up

Implement the spell checker and the hash table : Implement the spell checker and the hash table, respectively. Create a UML class diagram that describes your class design.

What are the final balances for each account : What are the final balances for each account by the end of 09/2018? And What are the total final balances for all account by the end of 09/2018?

Identify computers that may have been used for the attack : ISSC630 - Advanced Cybercrime Analysis Assignment - Cyber Analysis Essay, American Military University - identify computers that may have been used for attack

Process results from lower layers : Process these results from lower layers and pass the appropriate information to upper layers. Assess the security disadvantage of this layered approach.

User Account

All Pages