E-R diagrami. Entities and Relationships: Entities: The entities including the company, which is the owner of the warehouse; a warehouse is the 3Dvolume for the spatial database; a zone means a spatial part to store goods within a warehouse; a forklift truck refers to the vehicle working in the warehouse to help carrying the goods; a piece of goods means a piece of collection of the product that produced by the company and being stored in the warehouse; the fire alarm is a set of equipment installed on the celling of the warehouse to avoidhaving a fire; a fire extinguisher is an active fire protection device used to extinguish or control small fires spreading in different locations of the warehouse; the CCTV camera is Closed-circuit television cameras that can produce images or recordings for surveillance purposes and also spread out in the whole warehouse.Cardinality of Relationships: ·The company owns the warehouse and the warehouse belongs to the company, and the relationship is from one to many because a company can have many warehouses and one warehouse can only belongs to a company.·The warehouse contains different zones and zones are inside the warehouse, and the relationship is from one to many as one warehouse can have many zones and one zone can only inside one warehouse.·The forklift car passes through zones, and the relationship is many to many as one forklift car can pass through different zones and one zone can have many forklift cars. This relationship will be eliminated in the logic model. ·The fire alarm avoids fire accidents in zones, and the relationship is one to many because one zone can have many fire alarms and one fire alarm can only exists in one zone.·The fire extinguishers are installed in zones, and the relationship is one to many as one fire extinguisher can only in one zone and one zone can have not only one fire extinguisher.·The goods are stored in zones, and the relationship is one to many as a good can only stay in one zone and one zone may have many goods.·Each zone is monitored by CCTV cameras, and the relationship is one to many as one cameracanbe only placed in one zone and one zone may have more than one camera.Cardinality of Attributes Identifiers: Company name and location are the attributes for the company entity. Both of the attributes are mandatory with minimum value of 1 and also both of them are identifiers. Location and Name are the attributes for the Warehouse entity. Both of them are mandatory with minimum value of 1 and also both of them are identifiers. Location, number and zone use are three attributes of the zone entity. All of them are mandatory with minimum value of 1, and location is identifier. Zone use and number are not identifiers. Because there could be same zone use in different zones and the number of zone can change. Color, brand and purchase date are the attributes of the forklift car entity. All of them are mandatory with minimum value of 1, while only location is identifier. Because the brand of cars can be the same and they can also be purchased at the same time. Location and install date are the attributes of the fire alarm entity. Both of them are mandatory with minimum value of 1. However, only location is identifier, because the fire alarms can be installed at the same time. Location, purchase date and last replaced date are the attributes of the fire extinguisher entity. The location and purchase date are mandatory, while last replaced time is optional because the site of fire extinguisher can be newly established and has never replaced. At the same time, only location can be the identifier because the purchase date and last replaced time can be same for different fire extinguishers. Location install date and last replaced date are the attributes of CCTV camera entity. The location and install date are mandatory, while last replaced time is optional because the site of CCTV camera can be newly established and has never replaced. At the same time, only location can be the identifier because the purchase date and last replaced time can be same for different cameras. Location, import time and export time are the three attributes of goods entity. The location and import time is mandatory with minimum value of 1, while export time is optional with minimum value of 0, because the goods may haven’t decide the export time. As for identifiers, only location can be identifier, because the different goods can be imported or exported at the same time.ii. Business rulesEntity definition Company is defined as an organisation that sells good or service in order to do make profit. This company’s main business is selling sports wear to make money. A warehouse is a commercial building for storing goods. They are usually used by manufactures and they are often plain large buildings located in town and village. Normally goods will be sent to the warehouse after manufactured and warehouse will distribute them to the customers. A zone is an area or stretch of land having a particular characteristic, purpose, or use, or subject to particular restrictions. There are two zone in the warehouse. And the two zones are locating separately with distance between each edge. A forklift truck is a vehicle with a pronged device in front for lifting and carrying heavy loads. During the working time all tucks are working in the warehouse, it can move where it is needed with no limits of the zones. A fire alarm is a device making a loud noise that gives warning of a fire. Each zone will have at least one fire alarm to make sure the safety of the assets of the warehouse. And all the fire alarms are installed on the top of the ceiling. A fire extinguisher is a portable device that discharges a jet of water, foam, gas, or other material to extinguish a fire.There are two extinguisher in the warehouse and each zone will have one to extinguishing fire in time and minimize the lose due to fire. CCTVcameras are defined as video-recording devices in a TV system in which signals are not publicly distributed but are monitored, primarily for surveillance and security purposes. The cameras exists in all the zones to make sure all each corner in the warehouse can be monitored. Goods is the sportswear that the company selling and storing in the warehouse. Every cloth in this warehouse has an import time and export time that indicates the time they are in and out.Integrity constraints Company: Company name and location provides the unique identifier for the company entity. Warehouse: Warehouse location and name provides the unique identifier for the warehouse entity. Zone: Zone location provides unique identifier for the zone entity. Forklift Car: The car’s color provides unique identifier for the forklift car entity. Fire Alarm: The location of the fire alarm provides the unique identifier for fire alarm entity. Fire Extinguisher: The location provides the unique identifier for fire extinguisher entity. CCTV Camera: The location provides the unique identifier for the CCTV camera entity. Goods: The location provides the unique identifier for the good entity.iii. Derivations: To calculate the maximum amount of goods that a forklift car can carry requires the formulae: maximum carrying weight divided by average weigh of good. To calculate the surface area of warehouse requires the formulae: width of the warehouse times length of the warehouse. To calculate the volume of zone 1 requires the formulae: width of zone 1 times length of zone1 times height of zone1. To calculate the maximum amount of goods can be stored in zone 1 requires the formulae: surface area of zone1(length of zone1 times width of zone1) divided by the average surface area of a cloth. To calculate the distance of two extinguishers requires the formulae: square root of (the length of the warehouse’s square times width of the warehouse’s square).iv. Assumptions·The warehouse is a cube with is 60 meters length, 30 meters width, and 10 meters height.·Zone 1 has 30 meters length, 30 meters width, and 10 meters height. Zone 2 has 20 meters length, 30 meters width, and 10 meters height.·The distance between two closest edges of two zones (aisle) is 10 meters for the safety reason.·A warehouse can only belongs to one company while a company can own many warehouses to store goods.·The forklift cars are distinguished by different colors each truck will only has one color. And they can work where it is required no matter zones.·All the goods are put horizontally in a zone with no overlap and no space between clothes so location of goods is unique.·The export time attribute can be null in goods entity, when the goods are still in the warehouse.·Each zone will only have one fire extinguisher. Two fire extinguishers are located at the opposite corner of each zone. The distance can be calculate by their coordinate.·Every zone will have at least one camera and fire alarm. ·Fire alarms and CCTV caremas located on the top of the ceiling with the same height as the warehouse. Besides they will not overlap with others. Each of the fire alarm and caremas has its unique location. ·Knowing the height of Fire alarms and caremas are important so they are modled in 3D.代写CS Finance|建模|代码|系统|报告|考试编程类：C++,JAVA ,数据库,WEB,Linux,Nodejs,JSP,Html,Prolog,Python,Haskell,hadoop算法,系统 机器学习金融类：统计，计量，风险投资，金融工程，R语言，Python语言，Matlab，建立模型，数据分析，数据处理服务类：Lab/Assignment/Project/Course/Qzui/Midterm/Final/Exam/Test帮助代写代考辅导E-mail:[email protected]微信：BadGeniuscs 工作时间：无休息工作日-早上8点到凌晨3点如果您用的手机请先保存二维码到手机里面，识别图中二维码。如果用电脑，直接掏出手机果断扫描。

所有的编程代写范围：essayghost为美国、加拿大、英国、澳洲的留学生提供C语言代写、代写C语言、C语言代做、代做C语言、数据库代写、代写数据库、数据库代做、代做数据库、Web作业代写、代写Web作业、Web作业代做、代做Web作业、Java代写、代写Java、Java代做、代做Java、Python代写、代写Python、Python代做、代做Python、C/C++代写、代写C/C++、C/C++代做、代做C/C++、数据结构代写、代写数据结构、数据结构代做、代做数据结构等留学生编程作业代写服务。