Question: Draw an ERD to represent what you have discovered. Identify a business rule in this description and explain how this business rule is modeled on

Draw an ERD to represent what you have discovered. Identify a business rule in this description and explain how this business rule is modeled on the E-R diagram. Also draw a data model for this situation using the tool you have been told to use in your course. 2-46. Obtain several common user views such as a credit card receipt, credit card statement, and annual summary or some other common document from one organization with which you interact.
a. Prepare an ERD for one of these documents. Also prepare a data model for this document, using the tool you have been told to use in your course.
b. Prepare an ERD for another of these documents. Also prepare a data model for this document, using the tool you have been told to use in your course.
c. Do you find the same entities, attributes, and relationships in the two ERDs you developed for parts a and b? What differences do you find in modeling the same data entities, attributes, and relationships between the two ERDs? Can you combine the two ERDs into one ERD for which the original two are subsets? Do you encounter any issues in trying to combine the ERDs? Suggest some issues that might arise if two different data modelers had independently developed the two data models.
d. How might you use data naming and definition standards to overcome the issues you identified in part c?

Step by Step Solution

★★★★★

3.40 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

ERD and analyses for common user views Alternative One a Alternative One b Alternative One c Yes the same entity of CUSTOMER is present in both sets of ERDs this entity also appears to share the same ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

613-CS-DB (1613).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

1. To what events must the multiple listing service system respond? Create a complete event table listing the event, trigger, source, use case, response, and destination for each event. 2. Draw an...

1. To what events must the ticket processing system respond? Create a complete event table listing the event, trigger, source, use case, response, and destination for each event. 2. Draw an...

1. Draw an ERD for the Parrot Palace information system. 2. Indicate cardinality. 3. Identify all fields you plan to include in the birds and tricks tables. For example, in the bird table, you might...

Draw an ERD to represent what you have discovered. Identify a business rule in this description and explain how this business rule is modeled on the E-R diagram. Also draw a data model for this...

After completing a course in database management, you are asked to develop a preliminary ERD for a symphony orchestra. You discover the entity types that should be included as shown in Table 2-2. A...

After completing a course in database management, you are asked to develop a preliminary ERD for a symphony orchestra. You discover the entity types that should be included as shown in Table 2-2....

Table 2 - 3 Entity Types for Problem and Exercise 2 - 4 5 CONCERT SEASON The season during which a series of concerts will be performed. Identifier is Opening Date, which includes Month, Day, and...

Virtual Campus (VC) is a social media firm that specializes in creating virtual meeting places for students, faculty, staff, and others associated with different college campuses. VC was started as a...

After completing a course in database management, you are asked to develop a preliminary ERD for a symphony orchestra. You discover the following entity types that should be included: During further...

The beginning inventory was 320 units at a cost of $10 per unit. Goods available for sale during the year were 1,360 units at a total cost of $15,060. In May, 620 units were purchased at a total cost...

Consider the liquid surge system shown in Figure E. A high-level alarm is used to prevent tank overflow. After a high alarm sounds, the operator has ten minutes to respond before the ESD system turns...

A _ shareholder can sell her shares for a q , over the fair market value of shares. Multiple Choice minority, discount, majority majority, discount, minority minority, premium; majority majority,...

Impact of Transactions Involving Cash, Securities, and Receivables on Statement of Cash Flows From the following list, identify each item as operating (O), investing (I), fi nancing (F), or not...

Visit an organization that has implemented a database approach and interview individuals there about the security measures they take routinely. Evaluate each of the following at the organization: a....

Visit an organization that has implemented a database approach and interview an MIS department employee who has been involved in disaster recovery planning. Before you go for the interview, think...

Visit an organization that has implemented a database approach. Evaluate each of the following: a. The organizational placement of data administration, database administration, and data warehouse...

A USDJPY (Daily, #300) Product Settings Chart Type Time Scale Studies Draw/View *** QQ USDJPY (Daily, #300) 04/13/2022 H:126 307 L:125.334 O:125.348 C:125.650 MACD 12,26,9 MACD 2.0207 Signal 1.8847...

html sample solution

Let S = $85, K =$80,r=8% (continuously compounded), T -0.5, and 8-0. Letu -1.3,0 -0.75, and n-1. Calculate the value of a European call if A-0.652406 and B = -39.9601 a $11.001 b. $18.903 OC $15.494...