I will send a PDF file about the Database management system containing three questions that should be read in every single question paragraph.
1) question one contains 3 paragraphs:
The first one( is about writing an introduction to a database and it will be about any company (you can choose from Google)).
The second one( is Design an Entity Relationship (ER) diagram with appropriate relationships and cardinalities. The design must have at least four entities.)
The third one is about (. Relational model mapped from the ER diagram using MySQL). ( you should take a screenshot of every single paragraph like on ER Diagram must solve it in the Word file and take a screenshot from the app that you will use it to make a diagram.
2) question two contains 4 paragraphs:
A) Populate each relation with at least 5 tuples. Include in the report a snapshot of each relation with its tuples.
B) Write a query involving any two relations and translate it into a relational algebra expression.
C) Show visual explanation for the above query’s execution plan.
D) Show vertical fragmentation of any relation. Show the relation before and after fragmentation.
3) question two contains 5 paragraphs:
A) Show how internally performs a Select statement for any relation.
B) Create an index for a column in any two relations.
C) Create a new user with a password. (1 Mark) and grant global privileges for the created user.
D) Use two different aggregate functions for two queries.
E) Create two SQL triggers that must check conditions in two relations.
So these are all the questions please you must keep track of all conditions written on file.
if you need any info just send your question.
use MySQL for coding and any app for diagram.
adminX
Subject expert at Treatisely.