– Final product must be sent back as a Word document. – Queries should be written in MySQL code. – The diagram can be designed in any software desired, it has to be a ER diagram like this one: https://www.researchgate.net/publication/307110857/figure/fig3/AS:403359166156803@1473179727851/Entity-relationship-ER-diagram-of-Busan-traffic-data.png
Archive for the ‘Database design and optimisation’ Category
Posted in 
database coding
June 23rd, 2020 
Assignment BackgroundIn this assignment, you will develop a web application that will allow players to receivecards from a collectible card game and trade those cards amongst their friends. Thecard data used for this assignment is taken from the game Hearthstone. This is thesame data used in tutorial #8 a description of the structure of the […]
coding assigment
June 23rd, 2020 In this assignment, you will develop a web application that will allow players to receivecards from a collectible card game and trade those cards amongst their friends. Thecard data used for this assignment is taken from the game Hearthstone. This is thesame data used in tutorial #8 a description of the structure of the data […]
Database Management SQL
May 19th, 2020 1. (13 points) Clean and normalize the data. Submit your processed Excel file with a sheet for each relation/table. You do not need to submit screenshots of the Excel data.a. The raw data contains a multivalued field (Country) that must be resolved before loading the data into APEXb. The raw data contains a composite field […]
Mysql online data base
May 14th, 2020 Must develop and ERD diagram for an Online retail business of choice. The retail business must be able to collect CC payments. At minimum the developed relational database must collect and store the following information; Stock Customer Details Orders Suppliers Payments Returns Using the ERD diagram that was developed earlier in Part A now expand […]
Database
May 13th, 2020 A small university is in the process of creating its first database system, and you are the chief architect of this system. This university does not have majors, faculties, and departments, but it does have programs. A program usually has 5 courses (in real situation, a program usually has much more courses, but to make […]
team project
February 29th, 2020 The project charter is already done, just uploaded it so you know how it started off as. The presentation slides from slide 37 to 40 are the only relevant ones ignore the rest. In slide 39 all you have to write about is “Detailed Communication Strategy” and “Consideration of the impact of GDPR” You don’t […]
Designinga Relational Database
February 13th, 2020 Step 1. Understand the specification of the problemRead the following paragraph carefully. Multiple times, if necessary. Then follow the process we learned in Lab 2 to annotate the primary terms and actions. Basketball is one of the most popular sports in the United States. Basketball tournaments consist of games between two teams at various stages […]
SQL design and implement
February 10th, 2020 2. Design a database that will be used to store information for an IT Consulting Company that provides services for client organizations as well as purchases and resells equipment (servers, desktops, software, routers, etc.) to clients. Ensure that you diagram thetables, columns / datatypes, and table relationships.3. Create the database and tables from the previous […]
Database designer needed for creating an Entity Relationship Diagram (ERD)
February 5th, 2020 Hi there, I need todevelop an entity-relationship diagram (ERD) of songs on albums for popular music from 1950 to 2000. Please see the complete details of the project below:https://www.eecs.yorku.ca/course_archive/2019-20/W/3421N/project/er/ Please note that this has to be done in the Stanford style of E/R modeling. Thank you 🙂
