Will you be able to assist me?

Programming
Tutor: None Selected Time limit: 1 Day

I need help with my CIS 111 (Intro to Relational Database Management Systems) assignment. Will  you be able to assist me?

May 14th, 2015

yes...

RDBMS

RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

A Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd.

Table

The data in RDBMS is stored in database objects called tables. The table is a collection of related data entries and it consists of columns and rows.

Remember, a table is the most common and simplest form of data storage in a relational database. 

Field

Every table is broken up into smaller entities called fields. The fields in the CUSTOMERS table consist of ID, NAME, AGE, ADDRESS and SALARY.

A field is a column in a table that is designed to maintain specific information about every record in the table.

Record or row

A record, also called a row of data, is each individual entry that exists in a table. For example there are 7 records in the above CUSTOMERS table. 

A record is a horizontal entity in a table.

Column

A column is a vertical entity in a table that contains all information associated with a specific field in a table.

NULL value

A NULL value in a table is a value in a field that appears to be blank, which means a field with a NULL value is a field with no value.

It is very important to understand that a NULL value is different than a zero value or a field that contains spaces. A field with a NULL value is one that has been left blank during record creation.

SQL Constraints:

Constraints are the rules enforced on data columns on table. These are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the database.

Constraints could be column level or table level. Column level constraints are applied only to one column where as table level constraints are applied to the whole table.

Following are commonly used constraints available in SQL:

  • NOT NULL Constraint: Ensures that a column cannot have NULL value.

  • DEFAULT Constraint: Provides a default value for a column when none is specified.

  • UNIQUE Constraint: Ensures that all values in a column are different.

  • PRIMARY Key: Uniquely identified each rows/records in a database table.

  • FOREIGN Key: Uniquely identified a rows/records in any another database table.

  • CHECK Constraint: The CHECK constraint ensures that all values in a column satisfy certain conditions.

  • INDEX: Use to create and retrieve data from the database very quickly.

Data Integrity:

The following categories of the data integrity exist with each RDBMS:

  • Entity Integrity: There are no duplicate rows in a table.

  • Domain Integrity: Enforces valid entries for a given column by restricting the type, the format, or the range of values.

  • Referential integrity: Rows cannot be deleted, which are used by other records.

  • User-Defined Integrity: Enforces some specific business rules that do not fall into entity, domain or referential integrity.

May 14th, 2015

Thank you for your response, but my assignment is to:

Perform the following steps in MySQL:

Create the tables and relationships from the database design discussed in Lab 2. 
Add at least five (5) records into each table (Note: You must determine the field values). 
Create a query with all fields from the student table, where the student's last name is "Smith".
Create a query that includes students’ first names, last names, and phone numbers.
Create a query that includes instructors' first names, last names, and courses they teach. 
Include the following screen shots in a Microsoft Word document to show the completion of the steps above:

Screen shot depicting the tables created within MySQL.
Screen shots depicting the records added into each table.
Screen shots depicting the SQL code and the query results from each of the queries created.

I can use access to do this. Will you be able to help me?

May 14th, 2015

Actually in my system, Mysql is not installed....can you give me some time....to solve your problem..

and please give me the details of Lab2 ... i don know which tables you used in Lab 2

May 14th, 2015

Thank you. I was going to try to do it in access because I do not know anything about MySQL. I asked the professor will I be building anything off of  lab 2 and he said no. For my entities in that lab though I used STUDENT_ID, COURSE_ID, and PROFESSOR_ID

May 14th, 2015

Thank you. I was going to try to do it in access because I do not know anything about MySQL. I asked the professor will I be building anything off of  lab 2 and he said no. For my entities in that lab though I used STUDENT_ID, COURSE_ID, and PROFESSOR_ID

May 14th, 2015

Thank you. I was going to try to do it in access because I do not know anything about MySQL. I asked the professor will I be building anything off of  lab 2 and he said no. For my entities in that lab though I used STUDENT_ID, COURSE_ID, and PROFESSOR_ID

May 14th, 2015

Thank you. I was going to try to do it in access because I do not know anything about MySQL. I asked the professor will I be building anything off of  lab 2 and he said no. For my entities in that lab though I used STUDENT_ID, COURSE_ID, and PROFESSOR_ID

May 14th, 2015

Thank you. I was going to try to do it in access because I do not know anything about MySQL. I asked the professor will I be building anything off of  lab 2 and he said no. For my entities in that lab though I used STUDENT_ID, COURSE_ID, and PROFESSOR_ID

May 14th, 2015

Thank you. I was going to try to do it in access because I do not know anything about MySQL. I asked the professor will I be building anything off of  lab 2 and he said no. For my entities in that lab though I used STUDENT_ID, COURSE_ID, and PROFESSOR_ID

May 14th, 2015

Thank you. I was going to try to do it in access because I do not know anything about MySQL. I asked the professor will I be building anything off of  lab 2 and he said no. 

May 14th, 2015

Thank you. I was going to try to do it in access because I do not know anything about MySQL. I asked the professor will I be building anything off of  lab 2 and he said no. 

May 14th, 2015

what are the fields of these tables...Student_ID , Course_ID and Professor _ID

May 14th, 2015

MySql is very easy query language.... i think you should give try atleast once.... i know some good website from which you can learn mysql easily..

http://www.tutorialspoint.com/mysql/index.htm

otherwise i am here to help you

May 14th, 2015

Actually it is STUDENT_INFORMATION and under that I have my primary key as student_id. my attributes are stu_gpa, stu_name_stu_address, stu_start date, stu_email

May 14th, 2015

Trust me MySql is a pain. he said that we can do it in access. i prefer doing it in there

May 14th, 2015

Trust me MySql is a pain. he said that we can do it in access. i prefer doing it in there.

Under professor_information i have prof_id as the pk. attributes are prof_name, prof_gender, prof_dob, prof_course

Under course_information i have crs_id as my pk. attributes are crs_credit, crs_name, crs_section, crs_department, crs_section

May 14th, 2015

lol...okz..anyways.. i am solving your problem...for this ... i need some time...i will post the work in some hours ...

May 14th, 2015

lol. ok thank you. i will check back in a few or tomorrow. thank you again.

May 14th, 2015

okz...

May 14th, 2015

I was just checking in. I will check back later.

May 15th, 2015

sorry for late reply..

check the queries...

MYSQL Queries.docx 


May 16th, 2015

The queries look great. Wow. I understand each of them and now it is starting to make sense. From here what do I do next? Thank you so much for your help.

May 16th, 2015

hey ..sorry for late reply... i din see your message...

now you can download and install  mysql software from this site ...http://dev.mysql.com/downloads/windows/ 

After installation, you can write queries in MySQL Command Line ...you can learn easily..just give try.

May 17th, 2015

Sounds great. I will definitely give that a try and play around with it. Thank you so much. 

May 17th, 2015

Are you studying on the go? Check out our FREE app and post questions on the fly!
Download on the
App Store
...
May 14th, 2015
...
May 14th, 2015
Dec 4th, 2016
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer