1.given:
<address>
<billing>
<street>westchester park dr</street>
<city>college park</city>
<state>MD</state>
<zip>21121</zip>
</billing>
<shipping>
<street>westchester park dr</street>
<city>college park</city>
<state>MD</state>
<zip>21121</zip>
</shipping>
</address>
create XSD that enforces xml as below:
zip code has to be 5 digit
the first character of zip code always has to start 1-9
state code has to be 2 characters
state characters has to be capital letter
street, city, state and zip has maintain sequence
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
elementFormDefault="qualified">
<xs:element name="address">
<xs:complexType>
<xs:sequence>
<xs:element ref="billing"/>
<xs:element ref="shipping"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="billing">
<xs:complexType>
<xs:sequence>
<xs:element ref="street"/>
<xs:element ref="city"/>
<xs:element ref="state"/>
<xs:element ref="zip"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="shipping">
<xs:complexType>
<xs:sequence>
<xs:element ref="street"/>
<xs:element ref="city"/>
<xs:element ref="state"/>
<xs:element ref="zip"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="street" type="xs:string"/>
<xs:element name="city" type="xs:string"/>
<xs:element name="state" type="xs:NCName"/>
<xs:element name="zip" type="xs:integer"/>
<xs:simpleType name="zip">
<xs:restriction base="xs:string">
<xs:pattern value="[1-9][a-zA-Z0-9]{4}"/>
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="state">
<xs:restriction base="xs:NCName">
<xs:pattern value="([A-Z]){2}"/>
</xs:restriction>
</xs:simpleType>
</xs:schema>
1.given: <address> <billing> <street>westchester park dr</street> <city>college park</city> <state>MD</state> <zip>21121</zip> </billing> <shipping> <street>westchester park dr&
what is XML and list advantages what is JSON and list advantages compare and contrast XML vs JSON vs Flat File convert below xml to json <address> <billing> <street>westchester park dr</street> <city>college park</city> <state>MD</state> <zip>20020</zip> </billing> <shipping> <street>westchester park dr</street> <city>college park</city> <state>MD</state> <zip>20020</zip> </shipping> </address> correct below xml documents: <shipping> <street>westchester park dr</street> <city>college...
In the Python interpreter window (aka IDLE), create five variables: street, number, city, state, zip. street will hold your street name, number will hold your house number, city will hold your city, state will hold your state, and zipcode will hold your zip code. Print your address in the standard format for mailing addresses. Your print statements will utilize the variable names. Take a screenshot of the IDLE window. It should show your assignment of values to the variables, your...
[1] [30 points] Consider the relation R City, Street, Zip Code), where a tuple (c, s, z) is in R only if city c has a building with street s, and z is the zipcode for that address in that city. It is assumed that the nontrivial functional dependencies are: Street → Zip Code ZipCode → City City, [a] [b] [C] [d] [e] Determine all possible keys for R. Indicate all possible BCNF and 3NF violations. Decompose R as necessary...
in java
(Bank Account) Write a program that inputs in the full name, street address, city, state, zip code, and social security for new account. In addition, it inputs in the initial account balance and allows the owner of the new account to make one withdrawal followed by one deposit. Your program should calculate the ending balancing after the withdrawal and deposit made by the account holder. It should also find the count of each one of these bills $78,...
Write a java project that reads a sequence of up to 25 pairs of names and postal (ZIP) codes, street address, city, state, and 10-digit phone number for individuals. Store the data in an object designed to store a first name (string), last name (string), and postal code (integer), street address (string), city( string), state (string), and 10-digit phone number (long integer, contains area code and does not include special characters such as '(', ')', or '-' . Assume each...
Given CUSTOMERS = (SSN, fname, lname, cell pn, home pn, street, city, zip, state, free min, DOB, free SMS) RECORDS (from pn, to pn, start timestamp, duration, type) STATEMENTS (cell pn, start date, end date, total minutes, total SMS, amount due) PAYMENTS (cell pn, paid on, amount paid) DIRECTORY (pn, fname, lname, street, city, zip, state) pn is PK Provide queries in SQL 1.) List the full names of customers who has not made any calls for the last 7...
Write a java project that reads a sequence of up to 25 pairs of names and postal (ZIP) codes for individuals (sample input data is attached). Store the data in an object designed to store a first name (string), last name (string), and postal code (integer). Assume each line of input will contain two strings followed by an integer value, each separated by a tab character. Then, after the input has been read in, print the list in an appropriate...
In this assignment, you will write one (1) medium size C program. The program needs to be structured using multiple functions, i.e., you are required to organize your code into distinct logical units. The following set of instructions provide the specific requirements for the program. Make sure to test thoroughly before submitting. Write a program, named program1.c, that reads and processes employee records (data about an employee). Each employee record must be stored using a struct that contains the following ...
Visual Studios Help
Text file named Vendor.txt (vendor#, name, street, city, state,
zip, phone):
1,FCC,445 12th Street SW, Washington,DC,20554,888-225-5322
2, U.S, Copyright Office, 101 Independence Ave, Washington, DC,
20559,202-707-3000
3,CDC,1600 Clifton Road,Atlanta,GA,30333,800-323-4636
4,White House, 1600 Pennsylvania Avenue NW,
Washington,DC,20500,202-456-1111
5,Labor Statistics,Postal Sq Bldg,2 Mass
Ave,Washington,DC,20212,800-877-8339
6,AMTRAK,60 Massachusetts Avenue
NE,Washington,DC,20002,800-523-6590
7,U.S. Air Force,1690 Air Force
Pentagon,Washington,DC,20330-1670,800-423-8723
8,National Guard,111 South George Mason
Dr,Arlington,VA,22204,800-864-6264
9,Office of Govt Ethics,1201 New York
Ave,Washington,DC,20005,202-482-9300
10,IRS,1111 Constitution Ave
NW,Washington,DC,20224,800-829-1040
Windows Forms App (NET Framework) Visual C# Exercise...
An online company sells hundreds of office supply products on
its e-Commerce store. It has asked you to design and implement a
sales order processing system which will be used by users in our
Operations department to process sales orders. Here is an overview
of the sales order process. Customers make purchases by placing
orders. Each customer has a customer number and profile (such as
name, shipping address). To simplify the matter, each time an order
is placed, only one...