Pl design a suitable Logical Data Model for the use case attached herewith. make

Pl design a suitable Logical Data Model for the use case attached herewith.
make sure you include all the entities, attributes, primary keys, relationships, in the model.
make your own assumptions and list them along with the model
Please find the case study in the attachment and design accordingly

The local city youth league needs a database system to help track children that

The local city youth league needs a database system to help track children that sign up to play soccer.  Data needs to be kept on each team and the children that will be playing on each team and their parents.  Also, data needs to be kept on the coaches for each team.  Draw the data model, using Crow’s Foot Notation, described below.
Entities required: Team, Player, Coach, and Parent.
Attributes required:
Team:  Team ID number, Team name, and Team colors.
Player:  Player ID number, Player first name, Player last name, and Player age.
Coach:  Coach ID number, Coach first name, Coach last name, and Coach home phone number.
Parent:  Parent ID number, Parent last name, Parent first name, Home phone number, and Home Address (Street, City, State, and ZIP Code).
The following relationships must be defined:
Team is related to Player.
Team is related to Coach.
Player is related to Parent.
Connectivities and participations are defined as follows:
A Team may or may not have a Player.
A Player must have a Team.
A Team may have many Players.
A Player has only one Team.
A Team may or may not have a Coach.
A Coach must have a Team.
A Team may have many Coaches.
A Coach has only one Team.
A Player must have a Parent.
A Parent must have a Player.
A Player may have many Parents.
A Parent may have many Players.
You can use any drawing tool that you like as long as you can submit a PDF rendering of your ERD.  I suggest that you consider using diagrams.net (formerly called draw.io) which is a is free online diagram software. You can use it as a flowchart maker, network diagram software, to create UML online, as an ER diagram tool, to design database schema, to build BPMN online, as a circuit diagram maker, and more. draw.io can import .vsdx, Gliffy™ and Lucidchart™ files .  The tool can be found here:  https://www.diagrams.net/

A new company has developed a breakthrough Massive Multiplayer Online Role Playi

A new company has developed a breakthrough Massive Multiplayer Online Role Playing Game (MMORPG). An MMORPG is a computer game that is played over the Internet, connecting to a server where other players from around the world are also playing the same game. It is possible to ’see’ and communicate with these other players when online.
This company has recruited you to be their database designer. The database will manage the accounts of all players registered for this online game.
Each account must have a unique name. This will be the name that players use to log on to the game server.
Players need to pay a fee every month for having an account and, when their time runs out, the account must be blocked. It must only be unblocked when they have purchased more time.
Each account has a number of characters that have been created by the user. All characters have names and belong to a team and also have a skill level.
A table in the database logs any errors that occur. Make sure that certain errors have a certain type so that they are easier to find.
When playing the game with one of characters within the account, a player may find and pick up items.
These items are then stored in the character’s inventory. No item is unique unfortunately, so other characters may have the same item. The inventory has eight open slots for different types of items to go into. Items that are the same can stack on the same slot; therefore, a record must be kept of the quantity.
– You must create the following script files in MSSMS; to do this select Save from the File menu when you have finished typing the necessary code and save it to disk. Script files should have a .SQL file extension.
Complete the following:
Use the given initial ER diagram
Create a script file that includes the code for creating the database and all of the tables required in the project. PRIMARY KEY, FOREIGN KEY, UNIQUE and CHECK constraints must be included. Make use of the IDENTITY property, DEFAULT values and constraints. Remember that master/parent tables must be created first.
Create a script file to insert data into your user-created tables. Add at least four records for each table without foreign keys and seven records for each table that does contain a foreign key.
Create a script file to create the views as specified.
Create a script file to create the stored procedures as specified.
Create a script file to create at least two triggers for your project. There are no specifications for what types of triggers you must create. You should apply your knowledge and create triggers that you think would be appropriate.
Create a script file to delete the database that you create.
Create appropriate indexes on your tables.
You should validate all applicable arguments in the stored procedures where arguments are received.
Make use of iteration where appropriate.
Using the GUI (Graphical User Interface), create a full backup of your database and send it to a zipped folder.
Each script file must have a header section (using comments) that contains the following information:
Script file name
Programmer name (Clara Hammann)
Date
A short description of what the script file does
When commenting your code, both styles of commenting (– or /* */) may be used. Just remember to maintain consistency throughout your project.
Save all of the script files together with the backup onto a disk and hand it in with printouts of the script files. Provide clear instructions in your user documentation on how to execute the views and stored procedures, including the arguments that need to be passed to the stored procedures. In your user documentation you should include author and date details, together with the purpose and description of the project.

The website is https://www.zocdoc.com/patient/medicalteam. take screenshot of the functionality of the website

The website is https://www.zocdoc.com/patient/medicalteam.
take screenshot of the functionality of the website…you will use these screenshots to build your ERD and your SQLs(but now for now)…you should provide me with around 10 screens here (give or take one or two)…we will narrow this down later…but for now, this will give us a pool of screens to work with…be sure to include a link to the screen…
•    using the data from the screenshots as a guide, create an Excel spreadsheet similar to the sample in the Project write up…we will continue to modify this as we go…
what to turn in:
For this part of your project, you need to turn in your
first cut Data Model
your latest cut Excel Spreadsheet…
Screenshots and link
The Data Model should contain ENTITIES and RELATIONSHIPS…so you will need to take a first pass at Primary Keys…
You need to create your Data Model using SQL Data Modeler…

The website is www.zocdoc.com take screenshot of the functionality of the websit

The website is www.zocdoc.com
take screenshot of the functionality of the website…you will use these screenshots to build your ERD and your SQLs(but now for now)…you should provide me with around 10 screens here (give or take one or two)…we will narrow this down later…but for now, this will give us a pool of screens to work with…be sure to include a link to the screen…
•    using the data from the screenshots as a guide, create an Excel spreadsheet similar to the sample in the Project write up…we will continue to modify this as we go…
what to turn in:
For this part of your project, you need to turn in your
first cut Data Model
your latest cut Excel Spreadsheet…
Screenshots and link
The Data Model should contain ENTITIES and RELATIONSHIPS…so you will need to take a first pass at Primary Keys…
You need to create your Data Model using SQL Data Modeler…

Project : Data Governance and Policy All sources should be cited both in-text an

Project : Data Governance and Policy
All sources should be cited both in-text and in References using APA 7 format
At least 20 pages (Number of Pages Exclude references and cover page)
Case Study:
RealBeat LLC is a chemical manufacturing company that has existed for more than 50 years with over 150 employees. It has a strong Research and development (R & D) with many patents in its name. Other departments include Operations, Manufacturing, Shipping and Receiving, Accounting, Supply Chain, Sales, Marketing, Customer Service, and Legal. Its performance has been impressive, and it is even expected to grow rapidly in the next few years. The faster growth and without clear rules have resulted in inconsistencies and holes in its data and has affected the data integrity of its enterprise resource planning (ERP) and a Product lifecycle management (PLM) system. As a result, their data is not reliable and cannot be used for any meaningful planning. As it stands now, no amount of “AI technology” can help with that. As it is said, “garbage in, garbage out.”
Management realizing this has begun a data cleaning process but to ensure that all data stays clean and consistent as time goes on, it’s necessary to establish rules governing the creation and maintenance of data.
RealBeat LLC needs a data governance system to manage the business; its master data and transactional data with the expected growth.
Project:
Create a data governance document that will encourage discipline behavior across the entire organization, execute the compliance and governance practice, ensure policies, standards, and guidelines are maintained, and establish and monitor KPIs to track master data management.
The paper should at least contain the following sections:
•    Purpose:
•    Governance: Directives to manage policies, principles, and organizational bodies.
•    Policy: The requirements and standards that the Master Data Management (MDM) must follow.
•    Accountability and Responsibility:
•    Enforcement rules (compliance; ensure data is handled in ways that meet organizational goals.
•    Organization: Getting the right people, such as data stewards, in the right places.
•    Measurement: How is your company performing in relation to outlined goals?
•    Process: Lays out processes across the data lifecycle.

The website is www.zocdoc.com take screenshot of the functionality of the websit

The website is www.zocdoc.com
take screenshot of the functionality of the website…you will use these screenshots to build your ERD and your SQLs(but now for now)…you should provide me with around 10 screens here (give or take one or two)…we will narrow this down later…but for now, this will give us a pool of screens to work with…be sure to include a link to the screen…
•    using the data from the screenshots as a guide, create an Excel spreadsheet similar to the sample in the Project write up…we will continue to modify this as we go…
what to turn in:
For this part of your project, you need to turn in your
first cut Data Model
your latest cut Excel Spreadsheet…
Screenshots and link
The Data Model should contain ENTITIES and RELATIONSHIPS…so you will need to take a first pass at Primary Keys…
You need to create your Data Model using SQL Data Modeler…

The website is https://www.zocdoc.com/patient/medicalteam. take screenshot of t

The website is https://www.zocdoc.com/patient/medicalteam.
take screenshot of the functionality of the website…you will use these screenshots to build your ERD and your SQLs(but now for now)…you should provide me with around 10 screens here (give or take one or two)…we will narrow this down later…but for now, this will give us a pool of screens to work with…be sure to include a link to the screen…
•    using the data from the screenshots as a guide, create an Excel spreadsheet similar to the sample in the Project write up…we will continue to modify this as we go…
what to turn in:
For this part of your project, you need to turn in your
first cut Data Model
your latest cut Excel Spreadsheet…
Screenshots and link
The Data Model should contain ENTITIES and RELATIONSHIPS…so you will need to take a first pass at Primary Keys…
You need to create your Data Model using SQL Data Modeler…

**Serious inquires only, ER diagram and database concept included** **Python & M

**Serious inquires only, ER diagram and database concept included**
**Python & MySQL only*
*I’m on a low budget, so  if you would be willing to talk about the price*
This is the final phase of the project in which you have to implement the database (SQLite3, etc.), management system (Python) and write a final summary report. Follow the provided instructions:
Implementation
Use SQLite or any popular database server of your choice to develop the database part you proposed in the design document (relational schema diagram).
Use Python to connect your database and perform basic create, insert, search, update, delete, and other DDL and DML queries. Go through the tutorials provided. Show results in the output and provide few snapshots of the output.
https://www.digitalocean.com/community/tutorials/how-to-use-the-sqlite3-module-in-python-3