Reference no: EM13213584
Scenario:
Design a database to keep track of information for an art museum. The museum has many art objects. Each art object has a unique number, title, year, description and information about the author it was created by.
An art object can be a painting, a sculpture or other art object. A painting is described in terms of a technique used (oil, watercolors’… etc.), material (canvas, paper, wood etc) and style (modern, abstract etc). For each sculpture, the database should store the material it was made from (wood, marble, bronze etc.), style (modern, abstract etc), height and weight. For other art objects, the database should store the type (print, photo etc) and style (modern, abstract etc).
Art objects are classified into permanent and borrowed. For each permanent art object, the database should store the purchase date, price and its status (displayed or stored). For each borrowed art object the database should store the date borrowed, return date and the collection it was borrowed from. Information about the collection a borrowed art object belongs to includes its name (unique), type (private, museum etc), description, address, phone and contact person.
For each exhibition, the database stores its name, start date and end date, and information about all art objects it consists of. Information about artists includes his/her name (first, middle and last); number (unique), the date of birth, date of death (when applicable), country of origin and description.
The Deliverable:
• Database Design Report.
• Develop a Full Project Using the Oracle Developer (Form & Report Builder).
|
Earth system containing the strong-rocky-external layer
: The Earth system containing the strong, rocky, external layer of the Earth is called:
|
|
Stakeholder influences and interconnections
: Briefly describe what globalization means to you, to your company or organization, and to Canada using the principles of the Circle of Reflection. List influences that you believe it will have on stakeholders.
|
|
Identify the key players in this case
: Identify the key players in this case. Describe each player’s role and their relationship to each other. Describe the IS management position(s) that were missing at Clarion and suggest candidate(s) to fill the roles.
|
|
What proportion of the total variation in sales is explained
: cascade pharamacreuticals company developed the following regression model, using time-series data from the past 33 quaters, for for one of its nonprescription cold remedies: y=-1.04 + 0.24X1 - 0.27X2 Where Y = quarterly sales (in thousands pf cas..
|
|
Design database to keep track of information for art museum
: Design a database to keep track of information for an art museum. The museum has many art objects. Each art object has a unique number, title, year, description and information about the author it was created by.
|
|
What were carolines implicit costs in her new job
: Caroline received a $1 million payment from a lottery ticket. She decided to use the money to purchase a cupcake business. If Caroline had invested the $1 million in a money market account, she would have made $30,000 in interest each year.
|
|
Different real-world problems
: Choose two different real-world problems you have encountered. The problems should be chosen with the intention of applying persuasive thinking as a solution to one and scientific thinking as a solution to the other.
|
|
Would people be willing to make a large sacrifice to help
: Charles decides to go to an operabecause he does not want to waste the $100 he spent on the nonrefundable and nontransferable opear ticket, despite the fact that he would prefer to forgo the opera and go to a concert with Bette on the same night.
|
|
Analyze the principal objectives of punishment
: Which you analyze the principal objectives of punishment within the U.S. corrections system. What are the state and federal objectives of punishment?
|