Calculate the grocery store’s SUM salary and the AVG salary per position.
Question I’m having trouble with this. Imagine you work for an independent grocery store with 20 employees. The business owner
Read moreDatabase
Here is the collection of database questions & answers. These databases QNA’s will help you to learn various concepts.
Er diagram notation
Er diagram: An Er diagram is called an Entity-relationship model. It is a representation of data in picture form.
Read moreGiven a ER diagram, answer the question
Question Summary We have given an ER diagram where we have a different entity, attribute, connecting line. And the relationship.
Read moreConvert the virtual address into a physical address.
Question Consider a computer with 37 bit virtual addresses, Pages of size 1 MB, and 2^6 GB of byte addressable
Read moreListing entity types and relationship types
Question How does listing entity types and relationship types, become of use by stakeholders to develop a database? Summary In
Read moreDatabase Replication
Question: What exactly is replication? What purpose does it serve? What is the purpose of its use? What are the
Read more
Improving Database Design through Normalization.
Question: DATABASE NORMALIZATION Improving Database Design through Normalization. Continue improving the database (tables) you designed Here are your tasks: Discuss
Read moreWrite relational schema for the diagram.
SUMMARY The relational schema for the diagram includes 10 relational tables for the given 10 entities and there are no
Read moreDraw the ERD diagram to create relational model with reference to the scenario.
QUESTION Note: Please make sure that all the points/rules must be implemented. Draw the ERD Diagram to create relational model
Read more