Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Fastflight Database Project
Given the ERD and the data for each entity (table) do the following:
1- Define the primary keys, foreign keys, and secondary keys for each table.2- Link all tables according the ERD3- Design the input screens, output screens, and queries to:a. Enter datab. Display datac. Modify datad. Generate reportsa- FLIGHT table might look like this:
FLIGHT NUMBER
ORIGIN
DESTINATION
DEPART TIME
ARRIVE TIME
368
AUG
NAS
0923
1017
890
HPN
1410
1555
900
1535
1620
b. RESERVATION table might look like this:
FLIGHT DATE
PASSENGER NUMBER
RESERVATION CODE
SEAT NUMBER
AGENT NUMBER
7/6/04
ALER1098
912283
2A
412
6/1/04
BROT4657
289817
11A
686
BROT6182
318879
11B
c. PASSENGER table might look like this:
PASSENGER NAME
Alerion, Nathan
Brothers, Barbara
Brothers, Sam
d. RESERVATION AGENT table might look like this:
AGENT NAME
Alexis, Ramon
014
Madre, Jefferson
Vasquez, Wanda
Create the following:
1. Form to Add/Display/Modify/Delete FLIGHT information2. Form to Add/Display/Modify/Delete RESER VA TION information3. Form to Add/Display/Modify/Delete PASSENGER information4. Form to Add/Display/Modify/Delete RESERVATION AGENT information5. Query to display all Passengers information by using agent number as a search key.6. Query to display passenger name by using reservation code as a search key.7. Query to display agent name by using flight number as a search key.8. Report to view all passengers (grouped by agent number)9. Report to view all flights (grouped by destination)
Create an initial ERD for the new system that contains at least eight entities. Analyze each relationship to determine if it is 1:1, 1:M, or M:N
Construct a relational database for New York's fire departments and firefighters. The State of New York certifies firefighters throughout the state and must keep track of all of them, as well as of the state's fire departments.
Briefly explain the ARIES recovery algorithm, including the main phases, main principles and key ideas behind the algorithm such as WAL protocol and checkpointing etc.
What are triggers used for, and why are they significant in database systems? Give an example of situation where a trigger would be appropriate. What would implementation of this trigger look like?
Complete Entity-Relationship Diagram (ERD) for the database design. Include all maximum and minimum cardinalities on your diagram.
Describe how Harrah's treats customer data. What is customer lifetime value? Do you think this is an easier metric to calculate at Caesars or Wal-Mart? Why?
Draw E-R diagrams demonstrating each of the following relationships (create three meaningful examples for each relationship): One-to-One, One-to-many, One-to-Optional Many, Optional Many-to-One, Optional Many-to-Optional Many
Create an entity/relationship diagram (ERD) showing all your entities, attributes, and relationships. Sketch your ERD by hand or use a drawing program. Your diagram must beon a single page
At the end of the program, compare the total electricity usage accumulated in the program with the value provided in the header record, and print an appropriate message if the totals are not equal.
Provide a brief synopsis analyzing the detailed requirements of your prototype database design and design a database prototype that includes diagrams, data dictionary, design decisions, limitations, etc.
Develop an E-R diagram for the library database. The relation schemas for the library database. Normalization of the relations (your relations should be in 4NF), SQL statements for creating all tables in your ERD
Construct (i) a use-case diagram (ii) a class diagram (iii) System Sequence Diagram (iv) detailed Sequence Diagram or diagrams as appropriate and (v) a state chart for a car object/class according this scenario. Include appropriate properties for ..
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd