SCHEMA DESIGN & SDLFIELD TYPESBased on the schema below, which of the following are valid possible values for the nicknames field?GraphQL1type Pet {2 id: ID!3 name: String4 nicknames: [String!]!5 weightInKilograms: Float!6 ageInYears: Int7 owner: Person8}

Logical Design (20 Marks) • The conceptual design to be implemented following the rules of mapping. Details of all the mapping rules to be explained in a tabular format along with the primary key, foreign key identified after the relationship is mapped. • The logical schema designed to be shown with all the files and the relationship. • For the logical schema designed, all the files required data type, size and other details to be given in a tabular format. • Logical schema designed to be shown with all the arrows to show the relationship between the parent and the child relations

Describe the process of designing an efficient relational database schema for a web application.Answer:

Mapping of conceptual schema using the entity-relationship model into a relation schema, is achieved at the stagea.Physical-design phaseb.Logical-design phasec.Contextual-design phased.Virtual-design phase

Database Schema is the ________ design of the database.OptionsRelationLogicalPhysicalInstance

According to cognitive theorists, the use of schemas results in: