Reference no: EM13507597
1.Although you always wanted to be an artist, you ended up being an ex-pert on databases because you love to cook data and you somehow confused database with data baste. Your old love is still there, however, so you set up a database company, ArtBase, that builds a product for art galleries. The core of this product is a database with a schema that captures all the information that galleries need to maintain. Gal-leries keep information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price must be stored. Pieces of artwork are also classifed into groups of various kinds, for example, portraits, still lifes, works by Picasso, or works of the 19th century; a given piece may belong to more than one group. Each group is identifed by a name (like those just given) that describes the group. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique name, address, total amount of dollars spent in the gallery (very important!), and the artists and groups of art that the customer tends to like.
Draw the ER diagram for the database.
2.Answer the following questions.
Explain the following terms briely: UML, use case diagrams, statechart dia-grams, class diagrams, database diagrams, component diagrams, and deployment diagrams.
Explain the relationship between ER diagrams and UML.
|
State certain temperature a reaction that follow first order
: At a certain temperature a reaction that follow first order kinetics has a rate constant of to be equal to 2.5*10^-3 s^-1 the time in seconds required for the reaction to be 60% complete is
|
|
Does the relational model as seen by an sql query writer
: Does the relational model, as seen by an SQL query writer, provide physical and logical data independence? Explain.
|
|
Determine how much does the nail deflect downward
: A nail with a diameter of 1.00 mm projects 25.0 mm horizontally outward from a wall. how much does the nail deflect downward
|
|
Explain the equilibrium concetrations of i2, br2, and ibr
: For the reaction 2IBr (g) goes to I2 (g) + Br2 (g), Kc=280 at 150.0 degree celcius. Suppose that 0.900 mol IBr in a 2.00-L flask is allowed to reach equilibrium at 150.0 degree celcius, what are the equilibrium concetrations of I2, Br2, and IBr
|
|
Explain the relationship between er diagrams and uml
: Explain the following terms brie?y: UML, use case diagrams, statechart dia-grams, class diagrams, database diagrams, component diagrams, and deployment diagrams.
|
|
Estimate the wavelength of the standing wave
: A standing wave has been created on a string of length 1.5m. The frequency of the wave is 25Hz. What is the wavelength of the standing wave
|
|
Prepare a pension worksheet for the pension plan in 2012
: Prepare a pension worksheet for the pension plan in 2012 and prepare any journal entries related to the pension plan that would be needed at December 31, 2012.
|
|
Calculate the current in the loop
: A 2cm x 2cm square loop of wire in the xy plane with resistance .010 ohms has one edge parallel to a long straight wire. What is the current in the loop
|
|
Each technician is an expert on one or more plane model
: Each technician is an expert on one or more plane model(s), and his or her exper-tise may overlap with that of other technicians. This information about technicians must also be recorded.
|