Dept. of Computer ScienceDatabase Management Systems (CSC570.001) Database Project (40 Points)Consider an organization of your choice (e.g., manufacturing company, bank, accounting system, video rental, medical applications, retail store, Online_shopping, ) for which you are assigned to design and develop a database. Note that this is a real world database and therefore all entities, attributes, relationships, and assumptions must be reasonable.1) Define the information content of yourdatabase.a)-Define a set of entities and appropriate attributes for each entity. Minimum 10 entities.b)-Define a set of relationships that might exist between/among entities and attributes. Such relationships may include one-to-one, one-to-many and many-to-many associations.c)-Define a set of constraints that may be imposed on data.2) Define an E-R Diagram for your databasedesign.3) Define a relational schema for your databasedesign.Make sure that you have both one-to-many and many-to-many associations. a)-Define one or more realistic key(s) for every relation scheme. Use both simple and compositekeys.b)-Define a realistic set of Functional / Multi-Valued Dependencies (when appropriate) for every relationscheme.C-Check whether your relational schema is in 2NF, 3NF, BCNF, 4NF. d)-Put your relational schema in the highest normal form that is possible. Note that, every relation scheme should be in a specific normal form in order to have the relational schema in that normal form.NOTE: Please provide a detailed explanation for every question when appropriate.4)Implementation: Create your database using Oracle, orMySQL, or to Perform the followingoperations.A)You are required to execute SQL queries that include thefollowing operations. For each query, provide the SQL statements along with the output. For each of the following, try different SQL statements (i.e., using one relation, more than onerelations, ). Createtables: Select:selectinvolvingone/moreconditionsinWhereClauseselectwithaggregatefunctions(i.e.,SUM,MIN,MAX,AVG,COUNT)selectwithHaving,GroupBy,OrderByclauseNestedSelectselectinvolvingtheUnionoperation Insert:insertonetupleintoatableinsertasetoftuples(byusinganotherselectstatement)insertinvolvingtwotables Delete:deleteonetupleorasetoftuples:fromonetable,frommultipletables. Update:updateonetupleorasetoftuples:fromonetable,frommultipletables. CreateView:basedononerelationandmorethanonerelation:operateonView(i.e.,select,insert,delete,update,..)B)Also, create at least 4 different practical/useful triggers (writtenin MySQL) for your database to perform the followingtasks: enforcingreferentialintegrity-enforcingattributedomainconstraints-creatingdatabaselog-gatheringstatisticsC)Use MySQL and ColdFusion to create a Web-based applicationto enable the user to do the followingoperations:Add a record Delete a record Update a recordQuery (at least 3 select statements on one relation) NOTE: You can define your own hypothetical organization, provided that you give enough information as to what this organization does. You can make any assumptions about your database, provided that you define them and give reasons as why these assumptions are beingmade. Please let me know if you have any trouble in finding a suitable practical/operationalorganization. Attach any documents that you use to acquire the data for your database. This Project is graded based on accuracy and completeness and its practicality to real worldproblem. You need to provide a complete copy of the entire project:All the inputs, outputs, sql statements, sql results, codes for triggers, codes for html/ColdFusion, on- line operations screen shots, etc.Create a zip file for your project and put it on the blackboard.代写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点如果您用的手机请先保存二维码到手机里面，识别图中二维码。如果用电脑，直接掏出手机果断扫描。