Answer:
Step 1 : Create an Indicator Variable for metro cities using formula mentioned in formula bar.
Step 2: Filter the Data on Metro cities i.e. select only those cities with Metro Indicator 1.
Step 3: Paste this filtered data to a new sheet.
Step 4: Go to Data - Data Analysis - Regression
Step 5: Enter the range of Y-variable and X-variable as shown. Select Output range and click on residuals. It will give you Output Summary and the Predicted Values along with Residuals
Please see attachment
Answer:
Normalization
Explanation:
Converting a poorly-structured table and optimizing its database structure in order to reduce redundancy in relations can be referred to as database normalization. If the data is not redundant means that data inconsistencies and errors like deletion and insertion will get reduced or eliminated significantly.
Answer:
Explanation:
To develop the model for Creating the supertype/subtype relationship three diffrent types of notation is given bellow accrdig to the diagram attached.
1.Traditional EER (Enhance Entity-Relational) notation
2.Microsoft Visio notation
3.Subtypes Inside supertype note
<em><u>Traditional EER(Enhance Entity-Relational)notation for the international school of technology diagram is attached bellow</u></em>
The diagram consist of the following entity
Room Supertype
Media Entity Type
COURSE entity type
Section weak entity type
Schedule associatiative entity type
<u><em>Microsoft Visio Notation for the international school of technology is ashown in the diagram bellow.</em></u>
The diagram consist of the following entity
Room Supertype
Media Entity Type
Computer entity type
Instructor entity type
Time slot entity type
<u><em>Subtype Inside Supertype note Notation for the international school of technology is shown in the diagram bellow.</em></u>
The diagram consist of the following entity
Room Supertype
Media Entity Type
Computer entity type
Instructor entity type
Time slot entity type
Answer:
function validateForm(event)
{
event.preventDefault();
var phoneNumber = form.phoneNumber.value;
var userName = form.userName.value;
if(phoneNumber.length!=10)
console.log("Phone Number is Invalid");
if(userName.length<11)
console.log("User Name is Invalid");
}
Answer:
array = input("Enter the list of computer memory: ").split(',')
int_arr = [int(x) for x in array]
segment = int(input("Enter the length of segment to analyze: "))
list_len = len(int_arr)
segList = []
mini = []
for x,i in enumerate(int_arr):
seg = int_arr[i-1:segment+i-1]
if len(seg) == segment:
segList.append(seg)
for x in segList:
mini.append(min(x))
result = mini.index(min(mini))
print("Segment with the minimum memory is: ",segList[result])
Explanation:
The python program prints out the segment after analysis, with the smallest disk memory space. The code gets the array of computer rows from the user input and segments the array with the number of segment input, then the minimum is compared for all segments in the network.