Welcome to the Most Reliable Essay writing Service Online

IT 111 Database Design and SQL

by | May 22

IT 111 Database Design and SQL

Assignment

Part 1:

Instructions:

For the following each problems:

Write the purpose/mission statement for the database. Though this should not be long, it should be concise and complete as to the purpose of the database.Identify and list the initial entities from the provided requirements.Pair down the entity list based on duplication and other factors resulting in the final entity list that the database will be built.Write the relationships between each entity.Do not combine the above. Meaning, provide a list for #2 and a final list for #3. For #4 you can develop a ERD using the cheat sheet that was provided in Week 2 resources. Or you can simply write the relationships between the entities. For example:

STUDENTS has a MANY-TO-MANY relationship with COURSES

COURSES has a MANY-TO-One relationship with INSTRUCTORS

Complete all on a WORD document and upload via the assignment manager.

Problem 1 (requirements):

Melikealot Records has started a new business. To help them grow, they want you to develop a database for them that will capture their customers favorite songs. The shoppers would go online and via a list of music and its artist that will be displayed the shoppers would select and add to their favorite song list. This will help the business to know what musicians to carry and material they should carry for each singer. At anytime the customers can add and delete from their list.

Problem 2 (requirements):

Getemtobuyit Company wants you to develop a customer database. They want to store all purchasers’ orders and the products on each order. Shoppers of their company should be able to see all of their orders and every item on each order including the vendor of each product. Getemtobuyit would love to know via this database who their favorite product suppliers and best-selling products are at any point.

Part 2:

Instructions:

For the following each problems.

Based on your solution for Assignment 2 and the solution that is posted in Week 2 – Weekly Activities, do the following:

Create the ERD for this solution using VISIO.Add the appropriate attributes for each entity in VISIO.Identify the correct datatype for each attribute and note them by the attribute name.Apply the Primary Key to each entity by identifying the Key in VISIO for each entity.Complete all using VISIO and upload the .vsdx file via the assignment manager.

Problem 1.1 (requirements):

Melikealot Records has started a new business. To help them grow, they want you to develop a database for them that will capture their customers favorite songs. The shoppers would go online and via a list of music and its artist that will be displayed the users would select and add to their favorite song list. This will help the business to know what musicians to carry and material they should carry for each singer. At anytime the customers can add and delete from their list.

For customers, Melikealot Records would like to know common demographic type information. That is First Name, Last Name, Address, State, ZIP. In addition, they would like to be able to filter the data based on Gender, Race, and Age.

For the songs, the name of the song, the date recorded, the genre, and the record label where the song was recorded is suffice. For the musicians, their name is only needed.

Problem 2.2 (requirements):

Getemtobuyit Company wants you to develop a customer database. They want to store all purchasers’ orders and the products on each order. Shoppers of their company should be able to see all of their orders and every item on each order including the vendor of each product. Getemtobuyit would love to know via this database who their favorite product suppliers and best-selling products are at any point.

For customers, Getemtobuyit Company would like to know common demographic type information. That is First Name, Last Name, Address, State, ZIP. In addition, they would like to be able to filter the data based on Gender, Race, and Age in the future.

Each order should have a unique order number that the company will generate and also the date of the order. It will be important in the future to sort all orders based on their status (In Process, Shipped, Delivered).

Each product should contain the name of the product, the cost of the product to Getemtobuyit and the retail price that it is being sold to the public. In addition, they will need to know how many of the items are in inventory and what category the product falls in. For example, electronics, food, clothes, etc.

For the supplier, the need to know the name, and complete address of each. In addition, the contact name and contact information for each supplier is needed.

Part 3:

Instructions:

For the following problem 3

Write the purpose/mission statement for the database. Though this should not be long, it should be concise and complete as to the purpose of the database.Identify and list the initial entities from the provided requirements.Pair down the entity list based on duplication and other factors resulting in the final entity list that the database will be built.Write the relationships between each entity.Create the ERD for this solution using VISIO.Add the appropriate attributes for each entity in VISIO.Identify the correct datatype for each attribute and note them by the attribute name.Apply the Primary Key to each entity by identifying the Key in VISIO for each entity.Complete 1, 2, 3 with a WORD Document.

Complete 4, 5, 6, 7, and 8 using VISIO.

Upload the WORD and VISIO documents via the assignment manager.

Problem 3 (requirements):

Flyme Corporation is an airline and needs a database that can store the flights for their company, the passengers on each flight, the pilots on each flight, and the flight attendants for each voyage. Once complete the goal will be the customer can reserve a spot on a particular trip and also see their travel history and miles flown. The employees on the flight will also be able to check their upcoming weekly schedules and also see their history and hours in the air. In addition, every plane would need to be monitored for hours in use.

Pilots for Flyme have a distinct role. They can be the captain, co-pilot or Flight Engineer

Finally, Flyme would like to know the actual maintenance done on each plane. In other words, the date of the work, the work completed, by whom, and how many hours would be on the plane when maintained. The work on each plane will be completed by Flyme’s own maintenance workers.
The post IT 111 Database Design and SQL appeared first on My Assignment Online.

  

CLIENT TESTIMONIALS

The Service Is Okay. I won’t Complain

The writers on the website are courteous and the customer service responds quickly. My paper was handled well; They promised...

Writers here are very professional and are native British

Thanks a lot for helping me out with my PhD Thesis, Writers here are very professional and are native British!!

Jack, The United Kingdom

Very Very Helpful, and On time.

Very Very Helpful, and On time.

Adelio M, Spain

I scored complete A’s in 3 out of four courses

I scored complete A’s in 3 out of four courses

Anonymous, Illinoi Chicago

CLICK HERE  To order your paper

About Essaysmiths Assignment writing service

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for upto 20% off in their first Order. Our payment method is safe and secure.

 CLICK HERE to Order Your Assignment

 

Recently Posted Questions.

Order your Assignment today and save 15% with the discount code ESSAYHELP

X