View the step-by-step solution to:

Week 1 - "Business Rules in Data Modeling" Please respond to the following: Per the text, when databases are developed, they are modeled...

"Database Design and Implementation" Please respond to the following:

Now that you have learned the concepts of database models and you have practiced creating entity relationship diagrams, let us focus on the implementation of that design into a Database Management System (DBMS).
Based on the example of the business function / operation that you described within the Weeks 1-3 discussions, describe the queries that you would need to create in order to support the business function / operation in question.
Based on the database model described in the Week 2 and Week 3 discussions for your business function / operation, determine the major / minor issues that might arise when creating these queries.

Week 1 – "Business Rules in Data Modeling" Please respond to the following: Per the text, when databases are developed, they are modeled around business rules, so they accurately support a business funcTon or operaTon. Based on your experiences, idenTfy one (1) example of a business funcTon / operaTon. Explain the business funcTon / operaTon in the context of business data models. IdenTfy the business rules associated with your selected business funcTon / operaTon. Explain the manner in which such business rules would impact the design of a database. Explain at least one (1) way in which the business funcTon or operaTon would be aFected if these business rules were not adhered to in the development of the database. the enterprise resource planning is a funcTon of an operaTonal model which integrates very important funcTons of operaTons into one consolidated whole. Since every funcTon of the business and operaTon excluding Fnancial reporTng is embedded into the EPR, the data model on which the enTre ERP is designed. ±he data model has to be extensively managed in the sense that there are raTonal nodes between the di²eren domains as report generaTon and data management is used. the rules are that ERP has to be understood in the content of its enTrety. ±he major problem that occurs during the implementaTon of ERP systems vary between installaTon of an ERP to behavioral, procedural, poliTcal and organizaTonal changes, etc. that is predominantly noTceable only a³er the system is installed. several issues are also faced related to business processes integraTon, where the new rules built into ERP so³ware are incompaTble with the etablisheds ways of thinking and the norms of behavior embedded in the normal work rouTnes. this issue is parTcularly symptomaTc of companies that are implemenTng ERP for the Frst Tme and transferring their legacy data into the new system from excel spreadsheets, manual records, or old disparate applicaTons. Basically, the quesTon is that old data that have been used and stored for years for many reasoms appear approximate or even incorrect in the new ERP reality. So, be careful with your old informaTon, as it can be far from reality, and always make "pilot tests of new system outputs using legacy data. References: ´inney, S., & Corbeµ, M. (2207) ERP imlementaTon: A CompliaTon and Analysis of CriTcal Success ´actors. Business Process Management Journal, 13(3), 329-347.
Background image of page 1
WEEK 2 – "Relatonal DaTabase Model" Please respond To The following: In The Week 1 discussion, you identFed one (1) example of a business functon or operaton and The business rules associaTed wiTh ThaT business functon / operaton. You will build upon ThaT discussion as you describe The main enttes or objecTs of ThaT business functon / operaton in queston, as well as The manner in which They relaTe To one anoTher. Describe The main enttes or objecTs of The business functon / operaton. Specify The a±ribuTe ThaT would be The primary key for each entTy, and provide a ratonale for why you selecTed such an a±ribuTe. DeTermine wheTher The relatonships beTween each of The chosen enttes are one-To-one, one-To- many, or many-To-many relatonships. Justfy your response. Explain The key manner in which The business functon / operaton and The business rules associaTed wiTh ThaT business functon / operaton supporT The relatonships mentoned above. Also, explain The fundamenTal ways in which The relatonships could change, based on The inTerpreTaton of The given business rules. Example of a business functon STaFng: Managers of entre deparTmenTs decide The dutes and auThorites To his/her group. Managers alloT The Tasks and analogous auThorites To his/her Team in sTaFng. Business Rule: Employees can converse wiTh mangers of oTher deparTmenTs aT The tme of necessiTy or To a±ain additonal work knowledge. Enttes: Manager and Employees will be The enttes in The business functon of sTaFng A±ribuTes: ManagerID ManagerName ManagerOccupaton EmployeeID EmployeeNameEmployeeSkills jobs will be The a±ribuTes of The given enttes
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

The solution is... View the full answer


Running Head: DATABASE MANAGEMENT Database Design and Implementation 1 Running Head: DATABASE MANAGEMENT 2 Quarries:
After the analysis of week 1-3 discussions, there are various quarries that are...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online