Part OneDescriptionWhat to Hand InPart OneTotal points: 20 Total Weight: 2% Due: Tuesday, January 28, 2003, in class. DescriptionIn the course project, you will design and implement an application program to support, manage,and perform a set of tasks in an application domain For example, you may develop a program tomanage an on-line bookstore. Here the application domain is the on-line book business, and thetasks are those involving all activities in this business: controlling of the sales transactions,managing inventory, customers, suppliers, shipments, orders, web pages, etc. Your programwould have several types of users. For the on-line bookstore, the users may be customers,bookstore employees, shop owners, etc. Your program must provide support for each group ofusers. In order to perform these tasks, your program needs to use a database system to store andto retrieve the application data. This project is divided into 5 steps, starting with an overalldesign of the program and database, proceed to detailed database design, to the creation of thedatabase, to the testing of data and queries, to the final design, implementation and testing of theapplication program. Parallel to the system design and implementation, you also build a reportgradually to document your design and implementation.In this part, you will identify a real-world application domain, describe an application programthat manage the application domain, and design a conceptual schema of a database to be used byyour application program.1. You should choose an application domain that you would like to work with. The best choicesare those either you or someone else are likely to use in the future. In any case, you shouldavoid working on an uninteresting domain for the whole semester. Some possible domainsmay be a hobby, a favorite Web site, material from another course, a research project, etc. Itis strongly encouraged that you choose a domain where you can populate your database withreal rather than synthesized data. It should be emphasized that a solid design upfront will bevery helpful as you head into later stages of the project.2. The application must have a certain minimal complexity as specified below. Your databasemust be substantial (so it models a mini-world that is interesting enough and useful) yet nottoo big (so you will be able to build it within a given time frame). First you need to identifythe types of users of your application and a set of tasks to be supported by the program. Youmust identify at least two types of users with some tasks specific to each type. Your E/Rdiagram must contain a minimum of 5 entity types and a similar number of relationshiptypes. Your E/R diagram must include at least one example of each type relationship (one-to-one, one-to-many, many-to-many) and it must make logical sense (i.e. do not simply stick ina relationship to meet the criteria). Additionally various data types of attributes (string,integer, etc.) should be used. Although you are encouraged to use more advanced features,such as weak entity type, IS-A relationship, etc., it is not required.The following is a list of possible application domains just to give you some ideas and to helpyou to start. You are encouraged to be creative and find out your own application domains. - Movies domain: In this domain you would be modeling entities movies, their actors,directors, genres, playing times, reviews. There exist several sources on the WWW fromwhich you can get data to populate such a database. You can support various queries suchas finding specific playing times, finding movies in San Antonio directed by a givendirector. You can also support updates to the reviews section of the database (e.g.,viewers giving their own opinions). Another functionality is to provide personal profilesof people (i.e., the movies they like) and then try to recommend movies to them based onprofiles of viewers with similar tastes.- Books domain: In this domain you would be modeling entities such as books, theirauthors, topics (which may be a complex hierarchy). You may also model variousattributes of the authors, the institutions they belong to, etc. You can support a buy/sellservice of used books, books used in specific university courses. A personal profile,similar to the one for movies is also a possibility. Pointing an interested buyer to a websource to buy a book is also an interesting option.- Apartments: This domain would require modeling apartments and their properties, areasof town and their various properties (e.g., bus lines, crime rate, distance from variouslandmarks). You would provide an interface for offering apartments for rent, findingapartments. Some data can be found from local newspapers and other sources.- Database of web sites: In this domain, your basic entities would be web sites. You canmodel their various properties: topic, url, organization to which they belong, other sitesthey point to, reviews of the site, quality, cost of accessing, etc. Users can add new sitesthat they found to the database, add opinions about existing sites, or search for sites thatmay be of interest for them. See Yahoo.com for a partial inspiration.What to Hand InHand in a hard copy (preferred to be typed, or otherwise formatted and printed through a word processor) report with the following items. - A cover page with a title of the project, team number and a list of members in the team.The project title should reflect your application. Don’t use titles such as "cs3743 project."- A general description (about one or two paragraph) of the application that you plan tobuild in the project. This description should be brief and informal. You may want to pointout any unique or especially difficult aspect of your application. Your description will begraded on suitability and conciseness.- A list of functionalities that your application will provide to its users. You should providesufficient details to describe what your application is capable of doing. Your task is tooutline a reasonable set of functionalities to make the application interesting and useful,and at the same time to restrict the complexity and size of the system, so that you wouldbe able to complete the project in time. Obviously, your database must containinformation necessary to support this wide range of activities,