CS348: Introduction to Database Systems Assignment 4 (Fall 2019)
Database Systems代写 Overview: This assignment consists of two questions. As an aid to scheduling your work on this assignment,you should plan
(due on Friday November 29 at 5pm via crowdmark)
Overview: This assignment consists of two questions. As an aid to scheduling your work on this assignment, you should plan on spending three to five hours total on the questions.
Assignment submission: A PDF file “a4.pdf” containing your answers to both questions:
Page 1: An ER diagram, the first part of Question 1,Database Systems代写
Page 2: The second part of Question 1,
Pages 3, 4 and 5: SQL DDL defining the relational schema, the first part of Question 2, and
Page 6: The second part of Question 2.
Question 1.Database Systems代写
Assume your company is developing a digital camera online purchasing sys- tem for sale to camera stores. An initial analysis phase of the project has resulted in the following informal description of relevant data for the system.
- A store will be selling a variety of digital cameras and lenses. The digital cameras can have a combination of the following
- An ability to replace
- Cameras with an electronic
- Cameras with an optical
- Cameraswith a “through the lens” optical Database Systems代写
- Cameras with an optical
Note that any combination of these features is possible with the excep- tion that no camera will have more than one feature from the following set: {3, 4, 5}.
-
Properties of all cameras that are relevant include the manufacturer,
modelnumber, date of product release, sensor size, pixel number, retail price and the number currently in
- Properties of cameras without an ability to replace lenses that are relevantinclude a focal length range and an aperture
- Cameras with an ability to replace lenses are related to at least two or more
- Propertiesof a lens that are relevant include the manufacturer, model number, date of product release, focal length range, aperture range, Database Systems代写retail price and the number currently in
- Aprime lens is any lens with only one possible value for a focal length range, i.e., will have the low end of the range equal to the high end of the
- Online customers are either domestic customers or foreign
- Properties of customers that are relevant include a unique customer number,a customer name, an email address and a shipping
- Eachcustomer has any number of purchase orders (including possibly none at all). A subset of the purchase orders are in the process of being prepared for shipment and are therefore Database Systems代写
- Eachpurchase order is for either a camera or a lens, and will also have a selling
- Eachcamera or lens will have at least one customer
- A customer evaluation is given by an individual customer and con- sists of a score between 1 and 5 (from bad to good) and a customer comment.
Do each of the following two parts:
- Specify a conceptual design with an ER diagram that is capable of storing such information that formalizes as much of the informal de- scription as
- Clarify any parts of the above informal description that are not cap- tured by your ER
Question 2.Database Systems代写
Do each of the following two parts:
- Translatethe ER diagram you produced for the previous question into SQL DDL commands that define a relational The commands should include primary and foreign key constraints where appropriate.
- Write SQL queries that compute violations of any parts of your ER specificationor the informal description above that are not otherwise enforced by the relational schema.
更多其他：考试助攻 计算机代写 project代写 java代写 algorithm代写 代写CS 代码代写 function代写 作业代写 course代写 Data Analysis代写 app代写 物理代写 paper代写 r代写 金融经济统计代写 matlab代写
