Category: Databases

Complete the database design for Heather Sweeney
–Represent relationships (Recall how to transform 1:1, 1:N, N:M relationship)
–Create associative entities (intersection tables) when necessary （for many-to-many relationship)
–Enforce the referential integrity constraint for each relationship
–Develop an MS-Access Database based on the above transformation practices
Submit the MS-Access Database
– save it as (ABKHeatherSweeney.accdb)
–Your Database should contain your tables and define the relationships

Hey , this is a database project so be aware of any thing that is required in the file and make sure to check the Marking Criteria for the Project so you can follow up the requirements
This project worth 14 marks and will be distributed as in the following:
a) Identify the entity types, attributes, keys. (2 marks)
b) Identify the relationship and cardinalities. (2 marks)
c) Draw the ERD. (2 marks)
d) Schemas before Normalization. (1.5 marks)
e) Schemas after Normalization. (1.5 marks)
f) Create the tables. (1.5 marks)
g) Populate your tables with at least 5 rows. (1.5 marks)
h) Execute the requested sample queries. (2 marks)

Hey , this is a database project so be aware of any thing that is required in the file and make sure to check the Marking Criteria for the Project so you can follow up the requirements
This project worth 14 marks and will be distributed as in the following:
a) Identify the entity types, attributes, keys. (2 marks)
b) Identify the relationship and cardinalities. (2 marks)
c) Draw the ERD. (2 marks)
d) Schemas before Normalization. (1.5 marks)
e) Schemas after Normalization. (1.5 marks)
f) Create the tables. (1.5 marks)
g) Populate your tables with at least 5 rows. (1.5 marks)
h) Execute the requested sample queries. (2 marks)

All questions are written on the attached file.
We are a group of 4 girls
Names:
1- Fai Alshammari
2- Jood alzwuaidi
3- Aeshah alshanqiti
4- Sarah alzayer
Please read the instructions carefully and follow them.
Please don’t use images.
We need the codes (basic) not too much advanced
We need a powerpoint presentation for this project.

Hey , this is a database project so be aware of any thing that is required in the file and make sure to check the Marking Criteria for the Project so you can follow up the requirements
This project worth 14 marks and will be distributed as in the following:
a) Identify the entity types, attributes, keys. (2 marks)
b) Identify the relationship and cardinalities. (2 marks)
c) Draw the ERD. (2 marks)
d) Schemas before Normalization. (1.5 marks)
e) Schemas after Normalization. (1.5 marks)
f) Create the tables. (1.5 marks)
g) Populate your tables with at least 5 rows. (1.5 marks)
h) Execute the requested sample queries. (2 marks)

All questions are written on the attached file.
We are a group of 4 girls
Names:
1- Fai Alshammari
2- Jood alzwuaidi
3- Aeshah alshanqiti
4- Sarah alzayer
Please read the instructions carefully and follow them.
Please don’t use images.
We need the codes (basic) not too much advanced
We need a powerpoint presentation for this project.

# Read the networkg = nx.read_pajek(“karate.paj”)# Get basic information about the networkinfo = nx.info(g)print(info)# Get the number of nodesnum_nodes = nx.number_of_nodes(g)print(num_nodes)# Get the number of edgesnum_edges = nx.number_of_edges(g)print(num_edges)# Check if the graph is directedis_directed = nx.is_directed(g)print(is_directed)
Similarly, we can analyze networks in GraphML format:
# Read the networkg = nx.read_graphml(“wikipedia.graphml”)# Get basic information about the networkinfo = nx.info(g)print(info)# Get the number of nodesnum_nodes = nx.number_of_nodes(g)print(num_nodes)# Get the number of edgesnum_edges = nx.number_of_edges(g)print(num_edges)# Check if the graph is directedis_directed = nx.is_directed(g)print(is_directed)Finally, let’s analyze the network in GEXF format:
# Read the networkg = nx.read_gexf(“network.gexf”)# Get basic information about the networkinfo = nx.info(g)print(info)# Get the number of nodesnum_nodes = nx.number_of_nodes(g)print(num_nodes)# Get the number of edgesnum_edges = nx.number_of_edges(g)print(num_edges)# Check if the graph is directedis_directed = nx.is_directed(g)print(is_directed)Once we have converted the networks into graph objects, we can apply various functions on them and visualize the networks using the networkx package. For example, let’s visualize the karate network:
# Read the networkg = nx.read_gml(“karate.gml”)# Visualize the networknx.draw(g, with_labels=True)plt.show()There is a number of nodes and edges in an undirected graph. To visualize this graph, we can use the function nx.draw() and the parameter plt.show(). This allows us to see the graph and interact with it by moving and zooming. We can also save the figure.
For a directed graph, the arrows represent the edges. We can still zoom and analyze specific parts of the graph.
There are different layouts available in NetworkX, such as circular, spectral, and spring layout. Each layout arranges the nodes and edges in a different way.
We can perform basic analysis on the graph, such as checking the degree distribution. Degree distribution tells us how many nodes have a particular degree. We can plot the degree distribution to get a better understanding of the graph.
In the code, we create a function to plot the degree distribution of the graph. We use NetworkX functions to get the degrees of each node and calculate the unique degrees. Then, we can determine how many nodes have each degree.

You have been given this list of data (attached below). Break it down into smaller, well-formed relations and write relation schemas.
In a text/word file, write out the “Model” (i.e., relation schema) of your database based on the normalization process covered in class, i.e., break the list down to smaller, well-formed tables with each table only covering a single theme. You might want to add extra fields to make your database make more sense.
The relation schema should use the following format:
YourInitials_TABLE_NAME (Primary Key, other Elements, etc.) (if there is a foreign key, italicize it)
Prefix each attribute (including PKs and FKs) with your initials
Denote Primary Key, Foreign Key, and relationships. For each relationship, draw a directional arrow pointing from foreign key attribute towards its “parent” primary key.
Name the Word document as YourInitial_RelationSchema and upload it here.

Suppose you are the database analyst designing a database for a swim team league called Water Fun League (WFL):First, WFL wants to keep track of the swim teams in the league and their swimmers. Each swim team has an official name and a captain. A team is made up of many swimmers. WFL tracks each swimmer’s name, address, phone number, and date of birth. A swimmer can be a member of only one team.Second, WFL wants the database to keep track of the swim meets it holds. WFL has a numbering system for each swim meet. A swim meet also has an official name (such as “Father’s Day Swim Meet”), and the time and location are announced as soon as available. All teams in the league can compete at each meet.A meet consists of a variety of events (e.g., Men’s 50m freestyle, Women’s 100m butterfly, so on and so forth). The league keeps the League Record for each event as well as the corresponding national amateurs’ record as a reference. A swimmer can compete in multiple events at a swim meet.Design an ER diagram for the WFL database. Save it as YourInitialWFL and upload it here. Make any assumption/ business rules you may need. STATE THEM CLEARLY (required). (Use your initials to begin the name of each attribute, table, entity and the file)The ER diagram must include the necessary entity classes and all attributes specified in the description.Identifiers for all entity classes must be shown clearly.Relationships must be named, with cardinalities clearly shown.

Include the below numbers to organize the submission. DO NOT include the Questions or other content from the instructions.
1) Describe functional dependency only; NOT full functional dependency, or partial dependency, or transitive dependency. Hint – review the Functional Dependencies Topic in the Terms and Concepts discussion. While you may incorporate the formal definition, you must explain the concept in your own words, using fields names and values from this exercise.
Identify the functional dependencies that exist in the above figure. All attributes should be included at least once. There may be more than one row of functional notation needed.
2) Identify a primary key for the table in the above figure.
Indicate whether there are any alternate keys (for this table)
explain each of the above choices
3) Is the table in 3NF?
If not, explain why – (provide specific rationale, use field names and values in the table to demonstrate your understanding).
Explain what normal form the table provided is in.
4) Once you have determined the format for 3NF, provide the create table commands to create the tables as if you were to create the tables in SQLite or MS ACCESS.
APA guidelines, spelling, grammar, file name