Data Formats ( XML & JSON ) XML AND JSON | Generate XSD for Students

Generate XSD for Students

Generate XSD for the following XML.

XYZ School wants to store the details of students in an xml file. The following scenario helps in designing the XML document.

Here StudentList is the root tag. StudentList contains the entry of each student with rollno, name, age, address and department.

<?xml version="1.0" encoding="UTF-8"?>
<StudentList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="StudentList.xsd">
    <Student rollno="2017CSE0055">
        <name>
            <firstname>Savitha</firstname>
        </name>
        <age>20</age>
        <address>
            <doorno>35</doorno>
            <street>NRG Street</street>
            <city>coimbatore</city>
            <pincode>641038</pincode>
        </address>
        <department>CSE</department>
    </Student>

    <Student rollno="2017ECE1050">
        <name>
            <firstname>Vinitha</firstname>
        </name>
        <age>21</age>
        <address>
            <doorno>9</doorno>
            <street>Randy Street</street>
            <city>Chennai</city>
            <pincode>600025</pincode>
        </address>
        <department>ECE</department>
    </Student>

    <Student rollno="2017EEE2044">
        <name>
            <firstname>Steve</firstname>
            <lastname> Johnson </lastname>
        </name>
        <age>19</age>
        <address>
            <doorno>15</doorno>
            <street>CMH Road</street>
            <city>Bangalore</city>
            <pincode>560039</pincode>
        </address>
        <department>EEE</department>
    </Student>
</StudentList>

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" 
attributeFormDefault="unqualified">
<xs:element name="StudentList">
<xs:complexType>
<xs:sequence>
<xs:element name="Student" maxOccurs="unbounded" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="name">
<xs:complexType>
<xs:all>
<xs:element name="firstname" type="xs:string" minOccurs="0"/>
<xs:element name="lastname" type="xs:string" minOccurs="0"/>
</xs:all>
</xs:complexType>
</xs:element>
<xs:element name="age" type="xs:integer"/>
<xs:element name="address">
<xs:complexType>
<xs:sequence>
<xs:element name="doorno" type="xs:integer"/>
<xs:element name="street" type="xs:string"/>
<xs:element name="city" type="xs:string"/>
<xs:element name="pincode" type="xs:integer"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="department" type="xs:string"/>
</xs:sequence>
<xs:attribute name="rollno" type="xs:string"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

Evaluation Result:

 Result Description
Summary of tests
 *Note: All the test cases might not have same weightage
+------------------------------+
|  1  test run/ 1  test passed |
+------------------------------+

Comments

Must Read:

Algorithm Analysis and Design Concepts Data Structure and Algorithms Post-Quiz

RDBMS Data Definition Language | Create Payments table

Refer the below schema and create the table payments. Column Name Datatype Size Constraint Constraint name Reference table – Column name Payment_ID Varchar2 3 PRIMARY KEY PK_PAYMENTS Ticket_ID Varchar2 3 FOREIGN KEY FK_PAYMENTS_TICKETS TICKETS - TICKET_ID BD_ID Number 11 FOREIGN KEY FK_PAYMENTS_BOOKINGDETAILS BOOKINGDETAILS-BD_ID DISCOUNT_ID Varchar2 3 FOREIGN KEY FK_PAYMENTS_DISCOUNTS DISCOUNTS-DISCOUNT_ID Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+

Programming using Java Hands On - Arrays | Find & Display the position of a number

Write a java program to find the given number from the array of elements and display its position. If the number is not present in an array then display it as 0. Assume the position starts from 1. Sample Input 1 Enter the array size 4 Enter the values 9 32 17 4 Enter the number to find 17 Sample Output 1 3 Sample Input 2 Enter the array size 3 Enter the values 29 53 11 Enter the number to find 49 Sample Output 2 0 Result Description Summary of tests *Note: All the test cases might not have same weightage +------------------------------+ |4 tests run / 4 tests passed | +------------------------------+ TEST CASE PASSED

Logic Development | Object Oriented Programming Pre Quiz

Programming using Java Hands On - Control Structures | Bill Generation

Bill Generation Tom went to a movie with his friends in a multiplex theatre and during break time he bought pizzas, puffs and cool drinks. Consider the following prices : Rs.100/pizza Rs.20/puffs Rs.10/cooldrink Generate a bill for What Tom has bought. Sample Input 1: Enter the no of pizzas bought:10 Enter the no of puffs bought:12 Enter the no of cool drinks bought:5 Sample Output 1: Bill Details No of pizzas:10 No of puffs:12 No of cooldrinks:5 Total price=1290 ENJOY THE SHOW!!! Result Description Summary of tests *Note: All the test cases might not have same weightage +------------------------------+ | 6 tests run/ 6 tests passed | +------------------------------+

Count Binary Strings

1. You are given a number n. 2. You are required to print the number of binary strings of length n with no consecutive 0's. Note: In this problem, you are given a number n. All we need to print is the number of binary strings of length n with no consecutive 0's For example: Sample Input: 3 Sample Output: 5 How 5? We have a total of eight binary numbers for length 3, out of which we have 5 numbers in which there are no consecutive zeros. Input Format A number n Output Format A number representing the number of binary strings of length n with no consecutive 0's. Constraints 0 < n <= 45 Sample Input 6 Sample Output 21 Solution: import java.io.*; import java.util.*; public class Main{ public static void main(String[] args) throws Exception { // write your code here Scanner sc = new Scanner(System.in); int n = sc.nextInt(); int dp[][] = new int[n+1][2]; dp[1][0] = 1; dp[1][1] ...

UNIX Introduction to Unix | Pre-Quiz

Feedback Congratulations! You have passed by securing more that 80%. Question 1 Correct Mark 1.00 out of 1.00 Flag question Question text Solaris is the name of a flavor of UNIX from _____________. Select one: a. HP b. Sun Microsystems c. IBM d. Digital Equipment Corp Feedback Your answer is correct. The correct answer is: Sun Microsystems Question 2 Correct Mark 1.00 out of 1.00 Flag question Question text Match the following: HP-UX Answer 1 Choose... IBM Redhat Hewlett Packard Sun Microsystem AIX Answer 2 Choose... IBM Redhat Hewlett Packard Sun Microsystem Linux Answer 3 Choose... IBM Redhat Hewlett Packard Sun Microsystem Solaris Answer 4 Choose... IBM Redhat Hewlett Packard Sun Microsystem Feedback Your answer is correct. The correct answer is: HP-UX → Hewlett Packard, AIX → IBM, Linux → Redhat,...

Programming using Java Hands On - Arrays | Display array values

Write a java program to create an array of size ‘n’ and accepts ‘n’ number of integers from the user and display all the values from an array Sample Input 1 Enter the array size 5 Enter the values 10 15 62 94 78 Sample Output 1 10 15 62 94 78 Result Description Summary of tests *Note: All the test cases might not have same weightage +------------------------------+ |3 tests run / 3 tests passed | +------------------------------+ TEST CASE PASSED

RDBMS Data Definition Language | Test Your Understanding 2

Test Your Understanding 2 Modify the given query appropriately in order to create the department table using the schema given below, c onsidering the product table that you have already created. COLUMN NAME DATATYPE SIZE CONSTRAINT dept_id number 4 Primary key prod_id number 4 Foreign key dept_name varchar2 25 Unique dept_head varchar2 25 Not null Evaluation Result: Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+

Get's Answer

Search This Blog