New

Learn smart - Learn online. Upto 88% off on courses for a limited time. View Courses

Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

17 Pages
Management

Expected deliverables of the project position: 1. Overall deliverables: A. Target audience research report - defining the persona of the website audience and what their pain points ar ...

Type

Programming

Subject

Database

35 Pages
CIS 4935 Senior Project in Information Technology

Task: Purpose  Identify the product whose software requirements are specified in this document, including the revision or release number. Describe the scope of the product that is covered by th ...

Course

CIS 4935

Type

Programming

Subject

Database

University

University Of South Florida

12 Pages
MAN6905-Databases and Business Intelligence

Assignment “Flowers-4-Friends” is a new venture started by a group of young students, who want to setup an online flower ordering system. The website will enable customers to specify vari ...

Course

MAN6905

Type

Programming

Subject

Database

University

Edith Cowan University

9 Pages
Management

There are two objectives of this assessment: for the purposes of the client, the local Road Traffic Authority, you are to produce a design brief; and, for the purposes of the assessment you are to pro ...

Type

Programming

Subject

Database

QAC020C155H Data Modelling and SQL Language

Question

Answered

Question:

On successful completion of this module students will be able to

1.Understand fundamental concepts of database management systems such data independence, data models and database technologies

2.Be able to design and implement relational database systems

3.Be able to use manipulation and querying tools, including the use of Structured Query Language (SQL) for managing data held in a relational database management system (RDBMS)

4.Be able to test and document relational database systems

Jet Airline:

Jet Airline is an international airline company who is looking to develop an effective RDBMS to cater their needs for their growing business. As a junior developer, you have been asked to develop a database for New Jet Airline which will satisfy all their requirements.

The database should contain information about passengers, flights, departure, employees of the airline and aircrafts.

For passengers’- name, address, phone number and related information to store.

For employees- the company wants to record the name, address, salary, identification number and flight information.

For all these employees, it is required to record the qualification i.e. what kind of plane they can fly.

For planes, it is required to record the model and manufacturers of the plane. The airline has many aircrafts of certain type.

For flights the airline needs to keep the information, like flight number, origin, destination, departure time and arrival time. For the same source-destination, there can be many flights per week.

Relevant assumptions, if required can be made.

Database should be able to get the following information from the developed database:

1.Statistics of the payments, passengers, flights and employees

2.Number of bookings and cancellations for a specific day for specific journey

3.Number of flights for specific journey in a week.

4.Average number of passengers for specific source – destination

Tasks / Deliverables of the Assignment 1:

Marks are awarded for producing a properly documented system that meets the requirements as specified below:

Task 1:  Understanding of database [ 20%]

By relating your discussion to the above scenario where applicable,

1.Compare database systems to file based systems. Your discussion should include the advantages, disadvantages and limitations of each.

2.Discuss the characteristics of Hierarchical, network and relational database models and present practical applications where each one might be more appropriate to use.

3.Top-down and bottom-up are the two common approaches to a relational database design. Discuss the strengths and weaknesses of Top-down and bottom-up approaches and where each one might be appropriate to use. Comment on the approach you will use for this task and give your reasons.

Task 2: Conceptual Modelling [20%]

1.Identity all the possible  entities that you can find in the problem scenario and list them in alphabetical order.

2.Using Crow’s foot notation, design a conceptual data model for the New Airline database in a modelling tool of your choice. All entity types and the relationships between them must be clearly shown. Your design should show all cardinality and participation constraints accurately. Any enhanced features used (e.g. generalization/specialization) must be indicated.

Task 3: Logical Modelling [25%]

1.Discuss the principles of normalization and demonstrate by examples the steps you followed to achieve normal forms in relation to the given scenario. Your demonstration must show the full process with explanations, starting from UNF, 1NF, 2NF to 3NF. (There is no requirement here to go through the full list of attributes in the data model for the New Airline).

2.Produce an ERD with all the normalized entities containing the relevant attributes. State any de-normalization, if any, in all your relations and clearly state the reasons for de-normalizing relations in your implemented solution.

3.Map an ER model devised above into a set of logical relations in the relational data model.

Task 4: Physical Modelling [30%]

1.Produce a script using appropriate SQL commands (DDL) to create a set of database tables using MySQL relational database. Your tables should also show all constraints applied at either the column or the table level. You are expected to implement the database so that it meets the requirements described in the scenario.

2.By using appropriate SQL statements, populate all the tables in the database you created with some data. The data should be meaningful but does not need to be extensive.

Although much of your report will contain existing body of knowledge, you must write your assignment with your own words to demonstrate your understanding of the subject. You are required to follow the Harvard referencing system when citing others' work. An accompanying list of references must also be provided as part of your report. Extensively referenced work reflects the level of research you conducted in the process of producing the document. It is also an acknowledgement of other people’s work. Correct referencing demonstrates your academic and professional skill. It also reflects your academic honesty and thus to some degree protects you from cases of plagiarism.

Preparation Guidelines for Assignment Report

1.All components of the assignment report must be word processed (hand written text or hand drawn diagrams are not acceptable), font size must be within the range of 12 point to 14 point including the headings, body text and any texts within diagrams.

2.Standard and commonly used fonts such as Times New Roman, Arial or Calibri should be used.

3.Your document must be aligned left or justified with line spacing of 1.5.

4.All figures, graphs and tables must be numbered and labelled.

5.Material from external sources must be properly refereed and cited within the text using the Harvard referencing system.

6.All components of the assignment (text, diagrams. Code etc.) must be submitted in one pdf file.

QAC020C155H Data Modelling and SQL Language

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

178 More Pages to Come in This Document. Get access to the complete answer.

Specially designed essay help services have made MyAssignmenthelp.com one of the most prolific proposal essay help providers. We have arrays of expert essay writers who successfully deliver essay help depending on broad ranges of subjects and topics. We provide nursing essay help, MBA essay help, English Essay writing help and law essay help to students from different fields of study. Broad ranges of essay writing services assist us to offer quality contents within a specific time limit.

More QAC020C155H QAC020C155H Data Modelling and SQL Language: Questions & Answers

Q

Management

Expected deliverables of the project position: 1. Overall deliverables: A. Target audience research report - defining the persona of the website audience and what their pain points are. B. Keyword research findings - based on the target audience, the website purpose, and ...

View Answer
Q
icon

We aren't endorsed by this University

CIS 4935 Senior Project in Information Technology

Task: Purpose  Identify the product whose software requirements are specified in this document, including the revision or release number. Describe the scope of the product that is covered by this SRS, particularly if this SRS describes only part of the system or a single subsystem. Document ...

View Answer
Q
icon

We aren't endorsed by this University

MAN6905-Databases and Business Intelligence

Assignment “Flowers-4-Friends” is a new venture started by a group of young students, who want to setup an online flower ordering system. The website will enable customers to specify various combinations of flowers that will be delivered to a specified location and person, with an appro ...

View Answer
Q

Management

There are two objectives of this assessment: for the purposes of the client, the local Road Traffic Authority, you are to produce a design brief; and, for the purposes of the assessment you are to produce a reflection. So, this written submission should expertly mix a consultative style—that i ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?