Parker has recently started learning Windows Store apps development. He has learned creating UI of apps by adding UI elements. Now, he has been assigned a task to develop the UI of the Registration page. The UI of the app will contain the following fields:

Parker has recently started learning Windows Store apps development. He has learned creating
UI of apps by adding UI elements. Now, he has been assigned a task to develop the UI of the
Registration page. The UI of the app will contain the following fields:
User name
First name
Last name
Password
Confirm password
Date of birth
Gender
Receive notifications through email
Accept terms and conditions
In addition, the Register button should be provided on the interface. After adding the UI elements,
the UI should appear, as shown in the following figure.

The Expected UI of the Registration Page
Help Parker to accomplish the preceding task.

Solution:

<TextBlock HorizontalAignment="Left" Margin="96,103,0,0" Text="User Name" VerticalAlignment/>
<TextBlock HorizontalAignment="Left" Margin="96,103,0,0" Text="First Name" VerticalAlignment/>
<TextBlock HorizontalAignment="Left" Margin="96,103,0,0" Text="Last Name"VerticalAlignment/>
<TextBlock HorizontalAignment="Left" Margin="96,103,0,0" Text="Password" VerticalAlignment/>
<TextBlock HorizontalAignment="Left" Margin="96,103,0,0" Text="Confirm Password" VerticalAlignment/>
<TextBlock HorizontalAignment="Left" Margin="96,103,0,0" Text="Date of Birth" VerticalAlignment/>
<TextBlock HorizontalAignment="Left" Margin="96,103,0,0" Text="Gender" VerticalAlignmen/>
<TextBlock HorizontalAignment="Left" Margin="96,103,0,0" Text="Receive notifications through email" VerticalAlignment/>
<TextBlock HorizontalAignment="Left" Margin="96,103,0,0" Text="Accept terms and conditions" VerticalAlignment/>
<PasswordBox Margin="585,303,0,0"HorizontalAlignment="Left"VerticalAlignment/>
<PasswordBox Margin="585,303,0,0"HorizontalAlignment="Left"VerticalAlignment/>
<ComboBox HorizontaiAlignment="Left" Margin="585,353,0,0" VerticalAlignment  />
<ComboBox HorizontaiAlignment="Left" Margin="762,353,0,0" VerticalAlignment/>
<ComboBox HorizontaiAlignment="Left" Margin="939,353,0,0" VerticalAlignment/>
<ToggleSwitch HorizontailAlignment="Left" Margin="585,441,0,0"VerticalAlignment/>
<CheckBox HorizontaiAlignment="Left" margin="585,503,0,0"VerticalAlignment/>                                                                                      
<RadioButton content="Male" HorizontalAlignment="Left" margin="585,403,0,0" verticalAlignment/>
<RadioButton content="Female" HorizontalAlignment="Left" margin="681,553,0,0" verticalAlignment/>

Object-Based Logical Model

The ER model:

Views the real world as a collection of objects or entities and the relationship among them.

An entity:

Is any object, place, person, or activity about which the data is recorded.

Can be categorized as entity type and entity instance.

An entity can be of the following types:

1. Dependent entity
2. Independent entity

A relationship is:

1. Defined as an association among entities.
2. Depicted in a diamond shaped box with the name of the relationship type inside it.  

The following diagram depicts a relationship between the entities (TEACHER and STUDENT).

---------------------------------------------------------------------------------------------------------

• Consider the following statement:

      “A supplier ships certain parts.”

      Identify the entities and the relationship which exists  

      between them.

Entities: SUPPLIER and PARTS
     Relationship: SHIPS

Entities: SUPPLIER and SHIPS
     Relationship: PARTS

Entities: PARTS and SHIPS
     Relationship: SUPPLIER

Entities: SUPPLIER, PARTS, and SHIPS
     Relationship: SUPPLIES

Solution:

Entities: SUPPLIER and PARTS

    Relationship: SHIPS

----------------------------------------------------------------------------------------------------

The three types of relationships are:

1.  One-to-One
2.  One-to-Many (or Many-to-One)
3.  Many-to-Many

An attribute:

• Is a property of a given entity.
• Is depicted as ellipses, labeled with the name of the property. 

----------------------------------------------------------------------------------------------

An attribute is a property of a given entity, which is depicted as ___________, labeled with the name of the property.

Solution:

ellipses

--------------------------------------------------------------------------------------------

Consider the following statement:

     “A supplier ships certain parts. A particular part is not necessarily   
      supplied by only one supplier. No supplier supplies only a single  
      part.”

      What type of relationship is possible between the two
      entities?

One-to-One relationship

One-to-Many relationship

Many-to-Many relationship

Many-to-One relationship

Solution:

Many-to-Many relationship

--------------------------------------------------------------------

A subtype:

• Is a subset of another entity.
• Is always dependent on the supertype for its existence.

The attributes of a supertype apply to all of its subtypes.

The following diagram depicts the relationship between supertype (COURSE) and subtypes (STANDLONE and SEMESTER).

---------------------------------------------------------------------------------------------------

There are two types of suppliers. One type of supplier allows credit, while the other type insists on payment in cash before delivery. The manufacturer wishes to maintain separate information on these two types of suppliers. For the credit supplier, “credit period” and “credit limit” have to be recorded. For the cash supplier, “date of payment” has to be stored. Identify the subtype and supertype entities.

Subtypes: Suppliers and Cash

     Supertype: Credit

Subtype: Credit

     Supertypes: Cash and Suppliers

Subtypes: Cash and Credit

     Supertype: Suppliers

Subtype: Suppliers

     Supertypes: Cash and Credit

Solution:

Subtypes: Cash and Credit

     Supertype: Suppliers

Data Models

A data model is a description of the data in a database.

Data models can be broadly classified into the following categories: 

Object-based logical model

Record-based logical model

Database Management System

• A database is a collection of logically related data.
• Database Management System (DBMS) is the software required to perform the task of maintaining databases.

Management of data involves:

1. Defining structures for data storage.
2. Providing methods for data manipulation.
3. Providing data security.

• The main advantages of any DBMS is to:

1. Provide an efficient and easy way to store, update, and retrieve data.
2. Manage information about users who interact with the DBMS, and the tasks that they can perform.

Rationale

Database is an integral part of an organization. Aspiring database developers should be able to efficiently design and implement databases.

This knowledge will enable the developers to build robust database solutions.

This course will help students to understand the concepts related to relational databases as well as equip them with basic and advanced knowledge of SQL Server