Question

XYZ school wants to store the details of student and staff in a xml file. The following scenario helps in designing the XML document.  persons will be the root tag. persons will have the entry of each person with name, age, gender, address. A person can be either a student or staff. student will have rollno, standard and section. If staff, then staffid and subject. Every person must have an address with the following entry- doorno,street,city and state.​

Answer 1

Answer:

Explanation:

to store the described data we can use database rules.

Given sentence Persons will be the root tag can be converted into" PERSON" table with attributes Name , Gender , Age and address .

Then we move up further and we can see the second condition that is a person can be either a staff or a student in this scenario we will use optional database.

we will create a new table named "STUDENT" with attributes Roll no, Section and standard.

and finally we will normalize the tables and will write them in mono forms

According to 1NF we will split address into parts such as city ,State and door no etc.