Use XML Editor to create XML document that contains the following information.
We would like to store information about the vehicles and their owners. An owner is described by first name, last name, phone number, and address that consists of suburb name, street name, building number, and optional flat number. An owner owns one or more vehicles and each vehicle has only one owner. We need to store a date when an owner has purchased a vehicle. We consider two types of vehicles: cars and trucks. A car is described by a manufacturer name, model, year of manufacturing, and registration number. A truck has the same description as a car and additionally it is described by a capacity.
XML document should contain information about at least two owners, and at least two cars and one truck. The details are up to you.
Step by stepSolved in 2 steps
- Implementation difficulties for Dates and Times data types?arrow_forwardExplain the main principles that should be followed when arranging the fields where data is entered. Are there any circumstances that come to mind in which it would be OK to deviate from these guidelines?arrow_forwardYou have a table that contains the following fields: Last Name, First Name, Street, City, State, and Postal Code. There are 50,000 records in the table. What indexes would you create for the table? You have a table that contains the following fields: Book ISBN Number, Book Title, Author Last Name, Author First Name, Publication Year, and Publisher Name. There are 75,000 records in the table. What indexes would you create for the table?arrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education