Using a drawing tool, draw an ERD for the small charter plane business scenario.11.Using Dia, LucidChart, or another diagramming tool, draw a third normal form solution for the following data. Identify all keys.
Using a drawing tool, draw an ERD for the small charter plane business scenario.11.Using Dia, LucidChart, or another diagramming tool, draw a third normal form solution for the following data. Identify all keys.
Document Preview:
11.Using Dia, LucidChart, or another diagramming tool, draw a third normal form solution for the following data. Identify all keys. A health organization keeps data on its doctors and the hospital to which they are assigned. The following data is kept for each doctor: 12. Using a diagramming tool, draw a third normal form solution for the following data. Identify all keys. A college keeps track of students and the courses they take. The following data is kept for each student: 19. In the box below, write an SQL query statement that shows all of the data in a table called bank. 20. Given a table called bank that contains a varchar field called type, write an SQL query statement in the box below that shows all of the data contained in the table for an account type of savings. 21. Given a table called bank that contains a varchar field called customerLastName, write an SQL query statement in the box below that shows all of the data contained in the table sorted by customerLastName (in default ascending order). 22. Given a table called bank that contains a varchar field called customerLastName and a numeric field called salary, write an SQL query statement in the box below that shows the data for just these two fields for all of the records in the table with the customer last namesmith who have a salary greater than $100,000. 23. Given a table called bank that has a 1:N relationship with a table called customer, write an SQL query statement in the box below that shows a customer’s last name and their associated bank name. Note: The bank table contains the fields: bankName (a varchar field) and bankID (a numeric field that is a primary key). The customer table contains the fields: customerLastName (a varchar field), customerID (a numeric field that is a primary key), and bankID (a numeric field that is a foreign key). 26. Using a drawing tool, draw an ERD for the small charter plane business scenario. The type of relationship must be drawn for all…
Attachments:
. .
.
The post Using a drawing tool, draw an ERD for the small charter plane business scenario.11.Using Dia, LucidChart, or another diagramming tool, draw a third normal form solution for the following data. Identify all keys. appeared first on MY NURSING WRITER.
