1. Using your downloaded DBMS (MS SQL Server), create a new database.
2. Create the database tables based on your entities defining
   1. The attributes within each table
   2. The primary and foreign keys within each table

*****Show your database tables, tables attributes, primary and foreign keys*****

Do not forget to check the lesson slides and videos that show you how to convert an ER/EER into a database schema, and how to create a database and tables using MS SQL Server.

In this assignment, you will study databases and differentiate between the various database models and tools available to design databases.

Specify at least two real-life situations where you have seen a database in use and based on your observations, answer the following questions:

• How different would each situation be without the database?
• What are the components of the database or data storage system that you have seen in use?
• Which type of database system is being used in the establishments where you have seen the database? How did you recognize this type of data storage system?
• Why do these situations benefit from the use of databases? What are the factors that make it necessary to use databases in these examples?

Pick one of the database models and list at least two situations in which the model can be applied. You can choose to find the model used in the database that you find in your real-life situation and then answer.

Further, research the Internet for features of the tools that can help you create a database design. You can confine your search to:

• Erwin
• Visio
• Power Designer

Based on your research, would you recommend any of these tools for database design based on the information available on the Internet? Why or why not? You may discuss other tools in addition to these.

I already have a database in phpMyAdmin and need to create an html/php "SEARCH" page to retrieve the information from the database on to my localhost. Please post a php/html code that will create a search page and return the data from my phpmyadmin database. The 3 items I have on the database are first_name, last_name and birth_day.

There are eight different important factors in e-commerce website design, which are:

• Functionality
• Informational
• Ease of Use
• Redundant Navigation
• Ease of Purchase
• Multi-Browser functionality
• Simple graphics
• Legible text.

Topic: Go to an e-commerce website of your choosing and evaluate its effectiveness according to the basic criteria mentioned above.

You are a data analyst with strong backgrounds in database design and management. In fact, you have learned from education, mentors, and experience the art of collecting data and transforming data into business intelligence and your experience in database design and management complements your abilities to analyze data. Your hypothetical employer, Park University, is in the process planning a new employee payroll database and has asked you for assistance. The database will be standalone but will need to have ability to communicate with other ODBC and SQL Server databases. The overall purpose of the database will be to input employee data for 100-150 employees. The database will need to input time and process data needed to document payroll and to create payroll checks. Park University at this point needs to understand and review options so that cost to develop and maintain this payroll database are kept at a minimum but without compromising security. Park University has requested information and has asked you to address the following questions: Would a full-scale Database Management System (DBMS) or Relational Database Management Systems (RDBMS) be required in this case? Discuss and defend your answer in scholarly detail!! Could Microsoft Access be a good option in this case? Discuss and defend your answer in scholarly detail!! Could even Microsoft Excel be used in this case maybe as a secondary database support application for further data analysis and statistical models? Discuss and defend your answer in scholarly detail!! What Systems Development Life Cycle methodology would you suggest in this case for the overall planning, design, implementation, and maintenance of this database? Discuss and defend your answer in scholarly detail!! What else might you need to cover to help Park University determine what type of database to consider for the new payroll database? Include any other important conclusions or content you see fit to support this assignment.

1. Discuss the elements of a database system. Like

• The database schema
• Schema objects
• Indexes
• Tables
• Fields and columns
• Records and rows
• Keys
• Relationships
• Data types

2. Discuss the key components of a database management system architecture and how they collaborate.

3. Discuss why a database management system needs a good query optimizer.

You are interested in analyzing some hard-to-obtain data from two separate databases. Each database contains n numerical values -so there are 2n values total - and you may assume that no two values are the same.

You’d like to determine the median of this set of 2n values, which we will define here to be the nth smallest value. However, the only way you can access these values is through queries to the databases. In a single query, you can specify a value k to one of the two databases, and the chosen database will return the kth smallest value that it contains. Since queries are expensive (you pay $10 for each), you would like to compute the median using as few queries as possible.

Write a java method named findMedian(Database a, Database b), that returns the median value using at most O(log n) queries.

/*
Notes for your code:

Database a, and Database b here are special objects that you can query for the kth smallest item.

• If you call a.query(1), Database a will return the smallest item in it (and charge you $10)
• If you call a.query(5), Database a will return the 5th smallest item in it (and charge you another $10) and so on.
• Also, you can get the size of Database a by calling a.size(); (this will cost you nothing)
• And if you call a.query(a.size()) this will give you the largest element in Database a (and you will pay $10 of course)
• AND Note the important fact that no two values are the same (among both Databases)

Please give me a clear Java code with explanation !

public static int findMedian(Database a, Database b){} The head of the method should look like this !

- List the benefits of deploying Windows Server Update Services in the network

- Define the new features In the latest version of Windows Server Update Services

5a. When 4.355 grams of a hydrocarbon, C_xH_y, were burned in a combustion analysis apparatus, 14.72 grams of CO₂ and 3.014 grams of H₂O were produced.

In a separate experiment, the molar mass of the compound was found to be 26.04 g/mol. Determine the empirical formula and the molecular formula of the hydrocarbon.

• Enter the elements in the order presented in the question.
  

  empirical formula =

  molecular formula =

5b.
A 12.57 gram sample of an organic compound containing C, H and O is analyzed by combustion analysis and 17.83 grams of CO₂ and 10.95 grams of H₂O are produced.

In a separate experiment, the molar mass is found to be 62.07 g/mol. Determine the empirical formula and the molecular formula of the organic compound.

• Enter the elements in the order C, H, O
  

  empirical formula =

  molecular formula =

5c.

A 4.550 gram sample of an organic compound containing C, H and O is analyzed by combustion analysis and 6.452 grams of CO₂ and 3.963 grams of H₂O are produced.

In a separate experiment, the molar mass is found to be 62.07 g/mol. Determine the empirical formula and the molecular formula of the organic compound.

• Enter the elements in the order C, H, O
  

  empirical formula =

  molecular formula =