Develop an iteration schedule diagram using the information provided in the attached document. Create this schedule using either Microsoft Project or ProjectLibre.

(a) According to Graduating Student and Alumni Survey in 2019, among the 1230 respondents, 180 said that they expected difficulty finding a job after graduation. If we can reasonably presume that the percentage of people expected difficulty will be between 15% and 25%, obtain a sample size that will ensure a margin of error of at most 0.02 for a 90% confidence interval.

(b) A recent survey of 254 customers, selected at random from a database with 12,861 customers, found that 202 are satisfied with the service they are receiving. Find a 99% confidence interval for the percentage satisfied for all customers in the database.

(c) Independent simple random samples of 400 Hong Kong women and 380 Macao women were taken. Of Hong Kong women, 318 were found to be in the labor force; of the Macao women, 276 were found to be in the labor force. At the 5% significance level, do the data suggest that the labor-force participation rate of Hong Kong women is higher? Use the P-value approach to perform a hypothesis test.

System Architecture

Passing Lane is a small trucking company headquartered in Portland, Oregon. Passing Lane’s information system consists of a file server and three workstations where freight clerks enter data, track shipments, and prepare freight bills. To perform their work, the clerks obtain data from the server and use database and spreadsheet programs stored on stand-alone PCs to process the data. At your meeting yesterday, Passing lane’s president approved your recommendation to create a relational database to handle operations and provide links for the company’s shippers and customers.

Tasks

1. What would be the advantages of selecting an Internet-based architecture for Passing Lane’s system?

2.  Since the firm is growing rapidly, what design features should be included in the new system to ensure it can grow with the company.

3.  Given that Passing Lane currently uses computers for managing their operations, what design considerations should be given to legacy systems? Explain your answer.

Part 2:

1. Use MySQL Workbench to add a table to your database on the class server and name the table “Person”. Include these fields in the Person table:

LoginID should be the Primary Key of the table.

Add at least ten records to the Person table.

3. Add a Persons page, named person.php. This page should display the contents of your Person table in an HTML table by using SQL to read records from the database table. Use linked styles to decorate the page background, all headers and table cell contents. E.g., font family, font size, color, etc. Place the .css file in an appropriate application subdirectory as in the class examples.

The Delta Insurance Company is having a policyholder subsystem which has started giving trouble. Over the years, the application evolved from using fixed length, multi-record type files to using a hierarchic database to using a relational database. The programs did not change much, but the data structures changed radically. Program code was patched to provide for the new data structure. The amount of people-time allocated to policyholder maintenance grew 15% per year over the last five years and is now costing as much per year as it did in 1980 to develop the original application. No one ever considered reevaluating the subsystem for redevelopment, but they would like to now. Upon inspection, the documentation was found to be up-to-date and includes flow charts and data flow diagrams. There are no current diagrams of the data structure. There are also no historical files of decisions or of changes. Apply the concepts of change management to discuss how should the company get this application in order? What type( s) of maintenance should they consider for the next set of changes?

A loan company wants to design a database to track student loans. Each student attending school is eligible for a loan. A student may have more than one loan. A student may be registered, possibly at different times, in more than one school. Each loan should belong to only one bank. Each bank can approve as many loans as it desires. For each loan, the loan company will track: the student’s SSN, name, address, amount of loan, date of the loan, interest rate ( which may be different for each loan as determined by the bank), duration of the loan, monthly payment, remaining balance, school ID, school name and address, number of years the student has been at the school, bank name, bank branch, and bank ID. Draw an ER diagram. State any assumptions you make in the diagram. Note: You must use one of the automated database design tools such as: ER STUDIO ER Assistant Vision Enterprise or draw.io website.

Introduction to Database SHort answer question

-1)Can intersection data be placed in the entity box of one of the two entities in the many-to-many binary relationship? If yes, describe which one. If not, where can you put it? Explain.

-2)What is the difference between a record type and an occurrence of that record? Explain and give example(s).

-3)Name at least 4 entities, some sample attributes for each entity, and the primary key field for each entity, in a university environment .

4)How foreign key is used to set-up one-to-many relationships in relational databases? Explain and give example (example from the lecture is ok).

5) How to implement Many-to-Many relationship in a relational Database? Explain and give example (example from the lecture is ok)

6)Describe referential integrity problem in general. In the specific case of deleting a record in a table on the “one side” of a one-to-many relationship, how would referential integrity occur?

Part 1Write a narrative that describes what information you will store in a database. Be as descriptive as you can be.

Part 2Create an E-R diagram that corresponds to yournarrative. If you have fewer than three entities in your E-R diagram, revise your narrative!Remember that foreign key values should not be in your entities.Make sure that you include maximum and minimum cardinalities for your relationships.You can use a tool to create the E-R diagram or draw it by hand and photograph it.You can use any style of E-R diagram that you like.

Part 3Convert your E-R diagram into a set of tables. All tables should be 3NF.

Part 4Write an SQLscript to create this database. Your table definitions should contain primary key and foreign key constraints. There shouldbe at least one CHECK constraint.There should be at least one index defined.Your script should include enough INSERT commandsso thatat least one table has at least 20 records, and all tables have at least 3 records.

Part 5Create 10 queries for your database. Show both the query and the result of the query. Write an English language description of each query. Make sure that your tables contain enough records to show the result of your query. Your queries should include:

•2 examples of GROUP BY

•3 queries with INNERJOINs, one of which has at least three tables joined together

•1 query with a LEFT JOIN

•2nested queries

•1 example of a nested query that includes a NOT IN

•1 example of a query with an aggregate function

Create three MySQL database tables and write SQL scripts to read, insert, and delete data. The first database table will contain the names of at least four movies. The second table will be a list of actors who appear in the movies. The third table will be an associative table that describes the relationship between the actors and their movies (which actors appear in which movies). Actors and movies have a “many-to-many relationship,” meaning an actor can be in multiple movies and a movie can have multiple actors.

• Use the MySQL Database Instructions to create the three tables.
• Once the three tables are completed, create a “join” statement that joins data from all three tables. Remember that field names used in more than one table (ASIN, ActorID) must be fully qualified (i.e., dvdtitle, ASIN).
• The previous SQL query returns a separate record for each actor. Provide a way to group results from several records into a single row.

General guidelines for this interactive assignment:

• String values in SQL statements are always enclosed within single quotes. ASIN and Title are both strings and require single quotes. For instance, your insert statement will look something like this:
  $sql = “Insert into dvdtitles (asin, title, price) VALUES (‘$asin’, ‘$title’, $price)”;
• SQL debugging tip: check your SQL statement before you execute it. Put the following line of code immediately before the mysql_query($strSQL) statement.
• When retrieving ASIN from the querystring, remember that ASIN is a string, not a number.

• Explain in detail the process on how to group results from several records into a single row.

You are asked to design a database to support a Instant Recruitment System of casual staff for a school. The major business requirements are summarised below in the Mini Case: An Instant Recruitment System. You are asked to develop a detailed Entity-Relationship model for this mini case. Your ER model should consist of a detailed ER diagram integrated with itemised discussions on the features of the entities and relationships and all the assumptions you made where applicable. The ER diagram and the accompanying document should identify keys, constraints, entity types, relationship types, specialisation/generalisation if any, etc. You must use the same notation scheme for the ER diagram as the textbook (use UML notations as shown in the last page of the textbook, and don't use Crew Foot notations), and the ER diagram should be strictly in the way the textbook uses for.

1. The ER diagram should include, among others, representative attributes for all entity types, proper subclassing if any, and correct participation multiplicities for the relationship types. It should be meaningfully and well designed, and should also include all relevant and necessary aspects, and indicate any supplementary business rules if you decide to introduce.
2. Map the above ER diagram into a global relation diagram (GRD) All the attributes should be kept there too. Include in the diagram all the primary keys, foreign keys, and the multiplicity constraints. (
3. Please note that an ERD is the artefact of the conceptual database design phase, while a GRD is the artfact of the logical database design phase which relates to the relational models. As such, a good ERD should be conceptually more concise and the relationships there should in general remain so rather than becoming extra entities as in a relational model.