Jump to content
Sign in to follow this  
Jade

Generating XML and XSD from entity-relationship diagram

Recommended Posts

Error I receive while implementing this code:

Exception: cvc-complex-type.2.4.a: Invalid content was found starting with element 'employee'. One of '{contractemployee}' is expected.

What changes shall I make in my code to correctly implement the xml document from the given image

 

abc.PNG

Code:

XML:

<?xml version="1.0" encoding="UTF-8"?>
<company>
    <companyname></companyname>
    <address></address>
        <department>
            <dname></dname>
            <deptphoneno></deptphoneno>
            <deptfaxno></deptfaxno>
            <deptemail></deptemail>
                <employee>
                    <empid></empid>
                    <ename></ename>
                    <emailid></emailid>
                    <phoneno></phoneno>
                </employee>
                <contractemployee>
                    <name></name>
                    <phoneno></phoneno>
                </contractemployee>
        </department>
</company>

XSD:

<?xml version="1.0" encoding="UTF-8"?>
    <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
        <xsd:element name="catalog">
            <xsd:complexType>
                <xsd:sequence>
                    <xsd:element name="product" maxOccurs="unbounded" minOccurs="0">
                        <xsd:complexType>
                            <xsd:sequence>
                                <xsd:element name="productname" type="xsd:string"></xsd:element>
                                <xsd:element name="storagenumber" type="xsd:short"></xsd:element>
                                <xsd:element name="dimension">
                                    <xsd:complexType>
                                        <xsd:sequence>
                                            <xsd:element name="width" type="xsd:byte"></xsd:element>
                                            <xsd:element name="heigth" type="xsd:string"></xsd:element>
                                            <xsd:element name="depth" type="xsd:byte" minOccurs="0"></xsd:element>
                                        </xsd:sequence>
                                    </xsd:complexType>
                                </xsd:element>
                            <xsd:element name="description" type="xsd:string"></xsd:element>
                            <xsd:element name="supplier" type="xsd:string" maxOccurs="unbounded" minOccurs="0"></xsd:element>
                        </xsd:sequence>
                    </xsd:complexType>
                </xsd:element>
            </xsd:sequence>
        </xsd:complexType>
    </xsd:element>
</xsd:schema>

Edited by Jade

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×