实验一：数据定义及更新语句练习

实验一：数据定义及更新语句练习实验目的：熟练掌握用SQL语句实现数据库和基本表的创建、数据的更新。实验内容：（一）用SQL语句建立如下mySPJ数据库，包括S，P，J，和SPJ四个基本表(教材第二章习

stressed that promoting the comprehensive revitalization should focus on economic construction as the central focus with, pay special attention to grasp the implementation of five development concepts, deepening reform and promoting the all-round opening up, ensuring and improving people's livelihood, strengthen the construction of ecological civilization, "five priorities", play development mix. To with new development concept measure work, and command action, and training cadres, in implement implementation new development concept in the looking for opportunities, and build highlights, and expand advantage; to full deepening reform, break bound the aspects created vitality of system mechanism obstacles; to active advance full aspects opening, participation "in the cast Russian Economic Corridor" construction; to guarantees and improved livelihood, strongly won poverty battle; to strengthening ecological civilization construction, for sustainable development reserved space, for future generations left sky blue, and to green, and water clear of better homes. We must in-depth implement implementation new development concept, insisted to economic construction for Center, firmly caught development this first priority, absorbed make construction, heart no distractions caught development, speed up development "six big industry", in-depth implementation "three big engineering", active create "two big environment", out of aarticle quality more high, and benefits better, and structure more excellent of transformation development of road. To strengthen ecological construction. On March 22, the deep restructuring examined and adopted the opinion on perfecting compensation mechanism of ecological protection, proposed to explore the establishment of diversified ecological compensation mechanism, progressive realization of forests, grasslands, wetlands and other areas of focus and key ecological function and other important regional ecological compensation coverage, the ecological advantages of the region will be further highlighted. We need to go green eco-building, as the essential policy, in strict accordance with the State of main function region construction requirements, careful implementation and Xiaoxing 'an mountains forest ecological protection and economic restructuring plan for the construction of sky blue, ... Acts prohibited by picking up the remaining wells in standing timber. To focus on forest resource conservation, increase the acquisition and supervision of cold storage, no buy fruit, encourage support to leading enterprises, workers 'cooperatives as aunit, the contract management of forest resources, the rational protection and utilization of resources. To work actively towards policy aimed from the level of the State Forestry Administration formulated regulations to protect forest resources as soon as possible to achieve law and regulation to protect forest resources. Should focus on forest fire prevention. Fire safety is the first priority 实验一：数据定义及更新语句练习 一、 实验目的： 熟练掌握用SQL语句实现数据库和基本表的创建、数据 的更新。 二、 实验内容： mySPJ （一）用SQL语句建立如下数据库，包括S，P，J，和SPJ四个基本表(教 材第二章习题5中的四个表)，要求实现关系的三类完整性。 S(SNO,SNAME,STATUS,CITY); P(PNO,PNAME,COLOR,WEIGHT); J(JNO,JNAME,CITY); SPJ(SNO,PNO,JNO,QTY) 供应商表S由供应商代码（SNO）、供应商姓名（SNAME）、供应商状态 （STATUS）、供应商所在城市（CITY）组成。 零件表P由零件代码（PNO）、零件名（PNAME）、颜色（COLOR）、重量 （WEIGHT）组成。 工程项目表J由工程项目代码（JNO）、工程项目名（JNAME）、工程项目所在 城市（CITY）组成。 供应情况表SPJ由供应商代码（SNO）、零件代码（PNO）、工程项目代码（JNO）、 供应数量（QTY）组成，表示某供应商 供应某种零件 给某工程项目的数量为 QTY。 （二） 分别使用插入、删除、修改的方式更新基本表中的数据。 三、完成情况 createtable s ( 9 charprimarykey sno (), // 主键约束 20 charunique sname (), // 唯一值 statussmallint , 20 char city (), ); createtable p ( 9 charprimarykey pno (), // 主键约束 20 char pname (), the first responsibility of the forest, 26th spring area has fully deployed to the fire, has now entered the fire, we have to be on duty, and defend. Determined to overcome paralysis, must not "Twelve-Five" no fires in the past, the reduced requirements during the period. To apply strictly the party with the responsibility, must shoulder the responsibility of the Party Secretary in particular, really practice pipes, it can never shuaishouzhanggui, be sure to layer the implementation falls fire responsibility, to ensure that no major forest fires. To adhere to balanced, correctly handle the relationship between fire and project construction, industrial development, to "never miss or two." Second, to speed up the development of six major industries. Promote development in our region, the key is to give full play to resource advantage to build eco-oriented "big six" system, to create the new engine of economic growth. Firm confidence. Practice has proved that the "big six" of both central and provincial requirements, and meet the actual da hinggan mountains, through active efforts have been showing astrong momentum of development. So, in the "six" on development, we must be firm in faith, go all out, perseverance, one caught in the end, convinced that Castle is not relaxed, does not reach the target will never give up. Should focus on industrial projects. Project is to accelerate the industrial development of important support and backing. Industrial project construction, my area there are few in number, small size, low level problems. This year, the project as his party has "first project", we have to work hard to project construction. Especially effective during short, catching project shall not, slow, dragging not allowed. All localities should conscientiously implement the project leadership system, timetable, roadmap, and coordinate services, tracking the whole process forward, inverted durations, speeding up progress and seek practical results. Poised to break the project build Set challenges, to accelerate the pace of preliminary formalities, the enterprises have difficulties to pull one way and also help in atimely manner to help businesses market, enhance confidence, urging work as soon as possible. To strengthen the project analysis, proper risk analysis and improve project success rates. (Specific to the XX, we still want to make good use of agricultural advantages, relying on the upper reaches of the forest in the fresh air and XXX pure water and other resources, create high-quality, high-grade green food brands, truly reflect the original character. Meanwhile, adhere to the project as the breakthrough to promote economic development around the "six industrial chain" to pay special attention to forming projects, dig potential projects, focus on key projects, actively cultivating the new leading industries and new sources of economic growth). To promote investment. More accurate professional business, and based my industrial base and resources, aimed at national industrial layout