Question 2:Identify all the associated entities for a University Management System, their corresponding attributes, relationships and cardinality and design an Entity-Relationship (ER) diagram for it.
Related Posts
Consider a toy-store database has the following schema: Product(pid: integer, name: varchar(20), min_age: integer) Manufacturer(mid: integer, name: varchar(20), address: varchar(50)) Supplier(sid: integer, name: varchar(20), address: varchar(50)) Inventory(pid:integer, stock: integer) Manufactures(mid:integer, pid: integer) Supplies(sid: integer, pid: integer)
Question : Consider the following relations: Supplier(S#,sname,status,city) Parts(P#,pname,color,weight,city) -SP(S#,P#,quantity)
Question: Consider the E-R diagram of Question 2 and design the relational schema and the tables. Perform and show the Normalization till the required normal form. Implement the database using MS-Access and submit the screenshots along with your assignment response for this question.
List and describe briefly all the possible applications of a database management system for a University.
Create a database consisting of Name of Regional Center, Code of Regional Center,
(a) Discuss the advantages and disadvantages of hierarchical database management system in comparison with RDBMS.
0 comments:
Post a Comment
Let us know your responses and feedback