Reference no: EM131058062
Temporal changes: An E-R diagram usually models the state of an enterprise at a point in time. Suppose we wish to track temporal changes, that is, changes to data over time. For example, Zhang may have been a student between 1 September 2005 31 May 2009, while Shankar may have had instructor Einstein as advisor from 31 May 2008 to 5 December 2008, and again from 1 June 2009 to 5 January 2010. Similarly, attribute values of an entity or relationship, such as title and credits of course, salary, or even name of instructor, and tot_cred of student, can change over time.
One way to model temporal changes is as follows. We define a new data type called valid time, which is a time-interval, or a set of time-intervals. We then associate a valid time attribute with each entity and relationship, recording the time periods during which the entity or relationship is valid. The end-time of an interval can be infinity; for example, if Shankar became a student on 2 September 2008, and is still a student, we can represent the end-time of the valid_time interval as infinity for the Shankar entity. Similarly, we model attributes that can change over time as a set of values, each with its own valid time.
a. Draw an E-R diagram with the student and instructor entities, and the advisor relationship, with the above extensions to track temporal changes.
b. Convert the above E-R diagram into a set of relations.
It should be clear that the set of relations generated above is rather complex, leading to difficulties in tasks such as writing queries in SQL. An alternative approach, which is used more widely is to ignore temporal changes when designing the E-R model (in particular, temporal changes to attribute values), and to modify the relations generated from the E-R model to track temporal changes, as discussed later in Section 8.9.
Enculturation influence male and female
: 2. How does enculturation influence male and female gender roles? Is there a universal division of labor based on sex? Are gender roles static entities within each society? Are gender roles changing in the United States?
|
Semiannual coupon payments
: Harry Houdini Ltd issues a 10-year bond that pays a 4 percent coupon. The current market rate for similar bonds is 3 percent. Assume semiannual coupon payments. What is the maximum price that should be paid for this bond? (Round to the nearest dol..
|
Effective annual yield on investment
: Suppose an investor earned a semiannual yield of 6.4 percent (i.e. 6.4% per half year)on a bond paying coupons twice a year. What is the effective annual yield (EAY) on this investment?
|
Construct an e-r diagram for a car insurance company
: Each payment is for a particular period of time, and has an associated due date, and the date when the payment was received.
|
Convert the above e-r diagram into a set of relations
: Convert the above E-R diagram into a set of relations.
|
Research on distributed computing applications
: Distributed.net (www.distrbuted.net) is an organization that coordinates research on distributed computing applications. People and organizations can join Distributed.net and contribute idle computing power to ongoing research projects that requir..
|
Question regarding the conch republic electronics
: Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelley Couts, who inherited the company.
|
What proportion of hispanics listen primarily to advertise
: What proportion of Hispanics listen primarily to advertisements in Spanish? Suppose one source says that in the past the proportion has been about .83.
|
Use deriva gem to calculate the value
: Format requirement: Please submit your assignment in PDF or WORD format online. The whole assignment must not exceed 10 pages in length, with 1.5 line spacing, 12-point Times New Roman font, 1-inch (i.e., 2.54-cm) side and top/bottom margins.
|