Access Millions of academic & study documents

Performance Sql

Content type
User Generated
Subject
MySQL
School
Boston University
Type
Homework
Showing Page:
1/3
Running head: PERFORMANCE ASSESSMENTS 1
Performance Assessment
Name
Institution

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/3
PERFORMANCE ASSEMENTS 1
Performance Assessment
1. What did you enjoy most and least about designing and building the database?
In designing the database, the ER diagram was the most interesting part of the database creation
since it helped in developing the visual look of the database.
2. Which challenges were easiest and which were most difficult for you?
The easiest challenge for me was inserting data into all the tables using the INSERT ALL
command. The most difficult task in the database creation was inserting foreign keys since it
meant ensuring the data types of the field to be referenced had to be the same and I had to make
it an index first.
3. What do those responses tell you about your skills, work style, and work preferences?
I came to view I had knowledge in SQL and was efficient in database development since I have a
basic understanding of the SQL data types, commands and general queries. I would, therefore,
consider working as a database developer or database administrator as a field of work.
Implications of Findings
4. What would you do differently if you were designing and building the database again?
If I was building the database again, I would ensure that the data that will be referenced for the
foreign key would be noted first in order to avoid errors made when trying to create the foreign
key.
5. In what context would you use a non-relational database versus a relational database?
Give examples.

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/3

Sign up to view the full document!

lock_open Sign Up
Unformatted Attachment Preview
Running head: PERFORMANCE ASSESSMENTS Performance Assessment Name Institution 1 PERFORMANCE ASSEMENTS 1 Performance Assessment 1. What did you enjoy most and least about designing and building the database? In designing the database, the ER diagram was the most interesting part of the database creation since it helped in developing the visual look of the database. 2. Which challenges were easiest and which were most difficult for you? The easiest challenge for me was inserting data into all the tables using the INSERT ALL command. The most difficult task in the database creation was inserting foreign keys since it meant ensuring the data types of the field to be referenced had to be the same and I had to make it an index first. 3. What do those responses tell you about your skills, work style, and work preferences? I came to view I had knowledge in SQL and was efficient in databa ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Documents