(Solved): ASL developments is a software development company. They have several software models such as clou ...

ASL developments is a software development company. They have several software models such as cloud-based solutions as well as "off-the-shelf" applications (licensed software) and in many cases work personally with businesses to develop software for them specifically. They started off as a small Kickstarter organization but grew to become a medium-sized company. They require a database to keep track of their operations. Firstly, they retain a list of "customers". These customers are individuals that buy their licensed software or subscribe to their cloud-based software solutions. A customer can buy multiple software license and/or subscribe to multiple cloud services. Specifically, if a customer buys a software, it is recorded as buying a license for the software so say, a customer "John" buys a licensed key (Key: 8813U210-3BB2) for the email client software, it is recorded based on the license. Hence, a license key is associated with only one customer. The same applies for the cloud-based services as a person's subscription pertains to an "online license". While the licensed software and cloudsubscriptions are different from each other, the company also keeps a general table of data pertaining to their software projects in general. So, the email client software mentioned earlier is stored in this "software projects" table-it should be noted that it is connected to the software license and cloud subscriptions. A software project is associated with many software license s, but a license is associated with only one software project. The same is true for the cloud-based subscriptions. On the other hand, ASL also keeps track of the "clients" they have-clients are different from customers as they are companies that hire ASL to develop software for them. Information about the software developed for the clients are stored in the software project table mentioned earlier- a client may request several software. However, a software developed for a client is specifically for that client alone. Even if another client exist that wants the same software- a variation with different customizations would be made. Finally, software projects are associated with employees. Employees are involved in the coding, development, and maintenance of these projects. Hence an employee may be associated with many projects, and likewise a project is associated with many employees. The fields for which data is collected from the company are as follows: - Customer IR - Customer Names - Customer Contact - License.Kex - Startadate - Expiry Date - Price - Amount of Devices - Subscription - Duration - Renewable - Repewal Price - Software,lD. - Saftware.Name - Softwaredescription. - Softuare. Version - Contractual (i,e, Whether this is developed for a company or not) - Develormentatime - Releaser Date - Employee. ID - Employeruname - Emplovee. Role - Employee. Contact - Clientar - Clientaname - Client Contact Your Task: 1. List and organize the entiteies and their attributes, Indicate what the primary keys and foreign keys are. 2. Develop proper business rules for the relationships 3. Develop an Enterprise ERD 4. Develop an Enhanced ERD