Suppose that you are required to develop a simple database for a design firm using the following instructions:? ? The data

Wridemy Plagiarism Free Paper Writing Website. Visit us here Wridemy  Part 1 Suppose that you are required to develop a simple database for a design firm using the following instructions: § The database can be used by multiple projects. A project is composed of design items. § The organization has several departments: Architectural Department, Structural Department, Environmental Department, and Land Development Department etc. One or more departments may participate in one project. Any department can participate in several projects. § A department may employ many employees, but each employee may be employed by one department. § Each department is managed by only one of the employees. § The organization has a training program in which an employee may manage (or train) many other employees and each employee is managed (or trained) by one employee. § During the implementation of a project, project documents (reports or drawings) are generated. § One document is produced by one or many employees and an employee can produce several documents. A design item consists of multiple documents. § The developed database should provide the users with name of the project, its start-date, its end-date, contract price, design fee of each design item, involved departments, basic information of involved employees, the number of employees in the organization, the number of Licensed Professional Engineers etc.Develop an Entity-Relationship diagram based on the instructions above. Please explicitly indicate any assumptions you are making while building this E-R diagram.   Part 2 Develop relation schemas from the entity sets and relationships developed for part 1 and fill the relations with some envisioned (but somewhat reasonable) examples. (2-3 examples max.)Part 3 Normalize this dependency diagram to 3NF.  Part 41. Break up the dependency diagram below to create 2 new dependency diagrams, one in 3NF and one in 2NF. 2. Modify the dependency diagrams you produced in 4.1. to produce a set of dependency diagrams that are all in 3NF. To keep the entire collection of attributes together, copy the 3NF dependency diagram from 4.1 and then show the new dependency diagrams that are also in 3NF. (Hint: One of your dependency diagrams will be in 3NF, but not in BCNF).   Part 5Remember the requirements of 1NF, 2NF and 3NF and answer the following. 1. Is the table below in 1NF? Explain your answer. 2. Normalize the table in 5.1. to 2NF and show the resulting table(s). 3. Normalize the ‘Courses’ table below to 3NF. Assume the following: · Venue depends on course code only.· One course code can be taught by different instructors from different departments.· Different professors may have the same name.  In this assignment, you will code solutions to the four SQL problems described below. To run SQL code, you can use one of the ways mentioned below. What you need to submit are text files with the SQL commands that you come up with, one file for each question (Q1.sql, Q2.sql, Q3.sql, Q4.sql). PLEASE MENTION AT THE TOP OF EACH FILE, which database (e.g., Oracle, SQLite) you used for that question! I will execute the SQL commands from the text files you submit, using the same software you used, to see if they produce the expected results. You can also submit a README text file containing anything else you want to communicate to me, regarding your queries etc. Please reach out to me if you need one-on-one help. Ways to ‘do’ SQL:SQL is a data creation + manipulation language, so it’s best learned HANDS-ON (not just by looking at slides and reading about the syntax) – you need access to a relational database where you can create tables, enter data in them and do queries on the data (tables ← data ← queries).There are different ways to get your hands on a DB: use a browser page [a server runs the DB software, you simply access it from a page]; install a DB locally on your laptop/tablet/phone; use a ‘cloud-based’ DB [this is similar to, but more powerful than, accessing a DB via a web page].An easy way to practice running SQL queries is to use browser-based interfaces (nothing to download, no login needed) to create/query databases. Here are some sites that provide this form of access:* SQL Tutorial: http://www.w3schools.com/sql/default.asp* ideone: http://www.ideone.com* sqlfiddle: http://sqlfiddle.com/* Code School’s Try SQL: http://campus.codeschool.com/courses/try-sql/contents* SQLZOO: http://sqlzoo.net/ – has extensive tutorials* Another tutorial: http://www.sqltutorial.org/* w3resource: http://www.w3resource.com/sql-exercises/ – more tutorials* Khan Academy: https://www.khanacademy.org/computer-programming/new/sql* ‘Online SQL interpreter’: https://sql-js.github.io/sql.js/examples/GUI/ -JavaScript-based!Question 1 (40%) Write SQL commands to create the table below (create your own column names) and populate them with data (as many/few rows as you see fit (e.g., 25 employees, 15 meetings) you can start small, and add more rows later, to help write queries for Q2-Q4).Question 2 (20%) Write a query to output the most-self-reported symptom.Question 3 (20%) Write a query to output the ‘sickest’ floor.Question 4 (20%) The management would like stats, for a given period (between start, end dates), on the following: number of scans, number of tests, number of employees who self-reported symptoms, number of positive cases. Write queries to output these.Here are notes on the entities:• Employee [contains info about employees]: ID, name, office number, floor number, phone number, email address etc.• Meeting [contains meeting info, on every meeting between employees]: meeting ID, employee ID, room number, floor number, meeting start time (just an int between 8 and 18, standing for 8AM..6PM)• Notification [based on contact tracing, to alert employees who might have been exposed]: notification ID, employee ID, notification date, notification type (mandatory, optional)• Symptom [self-reported by employees, any of 5 symptoms]: row ID (1,2…), employee ID, date reported, symptom ID (1 through 5)• Scan [random scans of employees’ body temperatures]: scan ID, scan date, scan time, employee ID, temperature• Test [to record test details]: test ID, location (company or hospital or clinic etc), test date, test time, employee ID, test result (positive or negative)• Case [to record employees who test positive]: case ID, employee ID, date, resolution (back to work, left the company, or deceased)• HealthStatus [self-reporting by employees]: row ID, employee ID, date, status (sick, hospitalized, well)• time can be ints between 0 and 23, standing for 12AM to 11PM ‘on the hour’• the company has 10 floors, numbered 1 through 10• do feel free to assume anything else you need, to answer the questions below (please list these in a README)homeWork.docxThe post Suppose that you are required to develop a simple database for a design firm using the following instructions:? ? The data Wridemy. Visit us here Wridemy for plagiarism free papers.The post Suppose that you are required to develop a simple database for a design firm using the following instructions:? ? The data first appeared on.
. .
No Plagiarism in OriginalpapersOrg.

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more