User Account

All Pages

Define six columns from the project description

Assignment Help PL-SQL Programming
Reference no: EM132059322

In Week 1, you developed an initial idea to build a database.

You followed the systems development life cycle (SDLC) and got an idea to start with. Now, it is time to start building your database. What next?

The project description developed in W1 Assignment 3 is a first draft, so consider it a rough draft. This means that you should continue to develop your idea.

The next step is to select some nouns in your project description. For example, a project has invoices, invoice distributions, and suppliers as nouns. These nouns are entities, or tables, that would be used to create the E-R model. Then, the adjectives and verbs that describe the nouns would become the attributes, or columns.

Therefore, in the example that we considered, we might have the following entities and attributes: Invoices Invoice_Distributions Suppliers # Invoice_id # Invoice_distribution_id # Supplier_id Invoice_num Invoice_distribution_line_num Name Invoice_type Line_type Address Supplier_id Invoice_id

Using your knowledge of selecting entities and attributes, complete the following tasks for this week:

Review your project descriptions and come up with five entities and some attributes that describe the entities. Do not identify more than five attributes for each entity.

In a Microsoft Excel spreadsheet, define six columns (nouns) from the project description you submitted in W1 Assignment 3 that you consider key to your database.

These will be the tables for the database. Then, in the rows for each column, define the attributes (adjectives). You have taken your creative idea and started to move the nouns and adjectives you identified in a logical model-the E-R model.

This will give you a working outline of the tables that will be created in the final script. Assignment Deliverable After you complete the lab and course project, collate the information from both in a 3- to 4-page report in a Microsoft Word document.

Verified Expert

"This is a continuation of a previous assignment on a database. The topic is the airlines reservation system database. The database is supposed to contain information about traveler, flights etc. The conceptual design of the database and the ER diagram have been made in this assignment."

Reference no: EM132059322

Questions Cloud

Find an equation in slope intercept form : Find an equation in slope intercept form for the line y-intercept -2, and perpendicular to x+8y= -9 let lim f(x) = 9 and lim g(x) = 8. Find lim[3f(x)
The moralistic therapeutic deism is an accurate reflection : In your discussion, indicate to which of the points of Moralistic Therapeutic Deism you are responding throughout your post.
How do you prove the function is correct : A function f such that it is both even and odd. How do you prove the function is correct?
What is the net present value of project : If the company's debt-equity is .87, what is the weighted average cost of capital? What is the net present value of the project?
Define six columns from the project description : Review your project descriptions and come up with five entities and some attributes that describe the entities - These will be the tables for the database
Using implicit differentiation : Find the derivative of g(x) = log(x) , noting that g has inverse f (x) = ex and using implicit differentiation.
Discuss the pros and cons of this legislation : The Affordable Care Act ("ObamaCare") has been both praised and vilified. Debate the pros and cons of this legislation and of health-care reform in general.
What skills and techniques did the group leaders use : Briefly describe 1-2 situations in which this member was working. What thoughts, feelings, fears, etc. did the member articulate?
Find the exact values of the following functions please : Assume that the ? is an angle in standard position whose terminal side contains the point (-7?,-24?).

Reviews

inf2059322

10/9/2018 9:36:46 PM

What does the company have? What business projections does it have? Integration with other systems—plan how the current system can be integrated with other systems? Documentation and communication—describe how this vital part will be accomplished? Design for changes—prepare a plan for the future? Reusable resources The reusable resources need to meet the demands and the policies of the airline reservation system which includes all important details about system handling and then working over the ticket system. The airline involve money with documentation that includes the date of call and agent name as well. The focus is on the trip insurance that cover the airline tickets with some ticket values that can be salvaged. The covering of the change fees will generally cost less than insuring the entire ticket where the ticket can be reused for the penalty. The reuse of the resources can help in effectively working over the different methods and cover the expenses. Thank you for your support. I have received my work. It is up to the mark.

inf2059322

10/9/2018 9:33:23 PM

Analysis of the current system There are things which are about critical growing company with different number clients. The requirements are set with projection that demands for a better massive employee number. There are different events and the other activities that is set with stronger need of modifying. The setup is through mainly handling different activities.

inf2059322

10/9/2018 9:33:06 PM

•Outline the SDLC. The software development life cycle is the framework that is designed to perform the different software development steps. It is the process that works with the development team in software organization. It consists of detailed plans with developing, maintaining, replacing specific software.

inf2059322

10/9/2018 9:32:53 PM

Outline the database you would like to create. The airline reservation system would require information about traveler that includes details like first name, last name, sex, date of birth etc. The information is about requesting for concessions and perks like giving the rewards to the fliers who are flying frequently in the particular month. The customer view with the needs hold the check on availability of flights and ticket pricing and concessions.

inf2059322

10/9/2018 9:32:20 PM

The focus of the project is to work on implementing the airline reservation system for customer satisfaction. The normal process is followed till there is a manual filling of data and then processing it which could be used to cause a lot of inconvenience to administrator and customer. The use of database is mainly to facilitate the process with smooth reservations and fast ticket process with minimal work on the part of customer and the administrators. The database works on smooth reservation for airline tickets with minimal work that includes how the people are involved in it. Through this, the administrator, customer and broker are able to control information at different times. It includes the scheduling of flights with days and flights that have arrived. The list of passengers who are waiting in the given flight etc.

Write a Review

PL-SQL Programming Questions & Answers

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd