数据库SQL-ecture04(广东工业大学).pptVIP

Y.Xing Database Principles and Applications YAN XING(邢延) Ubiquitous Computing (普适计算) （Won’t be Tested ） (IV) Information Art 主页：/ii/infoart/ 研究机构：Georgia Institute of Technology, USA 用图像来展现人们想要观测的信息的软件技术和系统 背景 Beach InfoCanvas Beach InfoCanvas InfoCanvas Tutor IDatabase design Exercise: shop database There is a shop with the following information: Staff: ID, name, address, branch(store_branch) Branch: ID,name,staff, manager, merchandise(商品) Merchandise: ID, name, factory, price, model(defined by the factory), internal_ID(defined by the shop) Factory: ID, name, address, price Design ER diagram, and then convert it to the relational model. Exercise: Airport database keeps track of airplanes, their owners, airport employees and pilots Each airplane has a registration number, is of a particular plane type and is stored in a particular hanger. Each plane type has a model number, capacity and weight. Each hanger has a number, capacity and location. The database also keeps track of who owns which plane. Persons have name, address and phones. A person buys a plane on a particular date and cost. Airport database…. Each plane undergoes service many times. A service information contains date of work, nature, hours spent, cost, etc. Pilots and employees are persons. Pilots have a license number with validity and salary. Employees have a number, rank and salary. Each pilot is authorized to fly certain types of planes. Employees are involved in servicing of planes. Design E/R model * * Lecture 4 Information overload 1. Todays forecasted weather condition for Atlanta is shown on the top-left 2. Tomorrows forecasted weather condition for Atlanta is shown on the top-right 3. The current temperature is the height of the largest sea gull. The smaller seagulls are a scale, denoting 20, 40, 60, and 80 degrees. 80 is at the top, 20 at the bottom. 4. The days change for Coca-Cola stock is shown by either a sea shell (stock is up) or a waterm