Database design and optimisation High School

Visio Assignment

After reviewing Appendix C of Hands-On Database, use Visio to re-create one of the E-R diagrams provided in Appendix F of Database Design for Mere Mortals. Please note that the symbols used in Visio are not identical to those used in Database Design for Mere Mortals. You should create your diagram using symbols with similar …

Continue Reading
Database design and optimisation High School

Scenario Activity

Vince Roberts runs a vintage record shop in the University district. His shop sells 45s, LPs, and even old 76 RPM records. Most of his stock is usedhe buys used vinyl from customers or finds them at yard sales and discount storesbut he does sell new albums that are released on vinyl. For a couple …

Continue Reading
Database design and optimisation Graduate

Mysql online data base

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 …

Continue Reading
Database design and optimisation Undergraduate

Database

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 …

Continue Reading
Database design and optimisation Undergraduate

Database Systems

Draw an ER diagram using the IDEF1X Notation and ERWIN for the following two applications. If you discover that the following narrative is incomplete, make up reasonable explanations to complete the description. State clearly your assumptions. Your assumptions should not contradict the assumptions stated in the narrative. You may download a trail version of ERWIN …

Continue Reading
Database design and optimisation Undergraduate

team project

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 …

Continue Reading
Database design and optimisation Undergraduate

Assignment 1

Create a table with two columns. Name the table First Initial _ Last Name (e.g. John Dowwill create table j_dow). You have to audit all DML statements on your table. To do this you write two triggers: 1. To log any DML statements that users might run on this table. The results must be stored …

Continue Reading