Ask a question from expert

Ask now

Week 1. Can we have different conceptual schema design

2 Pages230 Words536 Views
   

Added on  2019-09-13

Week 1. Can we have different conceptual schema design

   Added on 2019-09-13

BookmarkShareRelated Documents
Week 11.Can we have different conceptual schema design for the same application?2.How database design process differs from a system design process?3.What are the lessons learned when you created your first ER-diagram?4.Is ER-Model helpful in providing all the required information about theapplication for which this conceptual schema has been designed?Week 21.How helpful are the SEVEN steps provided to you for mapping ER-Schemato a Relational schema?2.Is there a situation that is not covered by the SEVEN steps provided to youfor mapping ER-Schema to a Relational schema?3.What issues you see if you have to design Relational schema without ER-Schema?Week 31.How constraints can be enforced in SQL while implementing a given schema?2.Is it fine to use too many JOIN operations in a query?3.What issues you see if you have to design Relational schema without ER-Schema?4.How can we reduce the amount of space used by query execution?Week 41.Show an example data set organized in two different ways illustrating thedifference between the application-oriented and subject-orientedorganization of data?2.Why do some organizations prefer not to create a data warehouse? What areother options?
Week 1. Can we have different conceptual schema design _1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Medical and Surgical Conditions
|1
|7328
|209

Medical and Surgical Conditions
|1
|7328
|223

Medical and Surgical Conditions
|1
|7328
|330

Medical and Surgical Conditions
|1
|7328
|132

Medical and Surgical Conditions
|1
|7328
|498

Medical and Surgical Conditions
|1
|7328
|168