Databases | SQL | Oracle | MS Access Answers

Produce an entity relationship model for the proposed database system for Domingo Roof Works.  Use Integration Definition for Information Modeling (IDEF1X) standard.

Task 1 only

Produce an entity relationship model for the proposed database system for Domingo Roof Works. Use Integration Definition for Information Modeling (IDEF1X) standard.

https://drive.google.com/file/d/1cBMx_IECHS2f6FvA433w6sb2NlC4-Bah/view?usp=sharing

Task 1 only please

Produce an entity relationship model for the proposed database system for Domingo Roof Works. Use Integration Definition for Information Modeling (IDEF1X) standard.

https://portal.iie.ac.za/Student%20Manuals/CLDV6211_Cloud_Development_A/2021/POE.pdf

https://portal.iie.ac.za/Student%20Manuals/CLDV6211_Cloud_Development_A/2021/POE.pdf

Comment on her diagram, explaining which 10 changes you would recommend to improve the diagram to be more in line with the business rules. Also include improvements that would make it possible to implement the design in a relational database. Explain why you would make each change too, so she can learn from her mistakes.

A student can register for more than one degree over time, and lots of students can register for the same degree. • Each degree consists of a number of modules that you have to complete. And a module can be part of multiple degrees. The number of credits for the module should be stored in the database too. • A student can register multiple times for the same module, and the final mark and result should be recorded for each module registration. • The name, surname and student number should be recorded for each student. • A student also registers to study at a specific campus. Each campus has a name. Draw ERD

A launchpad hosts multiple launches over time, and each launch is hosted by exactly one launchpad. Each launchpad has a location. A launch requires a launchpad that hosts it, a launch vehicle, and the payload. For a launch and name should be recorded as well as whether it is a crewed launch or not. Each launch is performed by a launch vehicle. The serial number for the launch vehicle should be recorded. A launch vehicle can perform multiple launches over time. Each launch vehicle is of a specific launch vehicle type. The maximum thrust and whether it is reusable needs to be recorded for the launch vehicle type. Each launch vehicle type and payload is made by a specific manufacturer and a manufacturer can make many different launch vehicle types. Each launch carries one payload, and a payload is only carried by one launch. Multiple crew members can be carried on a crewed launch, and each crew member can be carried on multiple launches over time. Each crew member has a nationality needs to be recorded. Draw an ERD

 Dineo has heard that there are a lot of different kinds of databases out there. And she is trying to figure out what the differences are. Make an infographic illustrating the four different ways in which a DBMS can be classified. Include a description of each classification, as well as an example that is relevant to Dineo (remember, she is a college student). You may make use of any tool of your choice to create the infographic, as long as you can embed it in the document that you submit for the assignment.

The owners of a small computer repair shop would like to keep track of the repair jobs for computers they repair, the items used for each repair job, the labor costs for each repair job, the repairmen performing each repair job, and the total cost of each repair job.

When customers bring their computers in to be repaired, they make a deposit on the repair job and are given a date to return and uplift their computer. Repairmen then perform repairs on the customers’ computers based on the repair job, and detail the labor costs and the items used for each repair job.

When customers return they pay the total cost of the repair job less the deposit, collect a receipt for their payment, and uplift the repaired computer using this payment receipt.

Identify and write the cardinality constraints

And make ERD with cardinality

The owners of a small computer repair shop would like to keep track of the repair jobs for computers they repair, the items used for each repair job, the labor costs for each repair job, the repairmen performing each repair job, and the total cost of each repair job.

When customers bring their computers in to be repaired, they make a deposit on the repair job and are given a date to return and uplift their computer. Repairmen then perform repairs on the customers’ computers based on the repair job, and detail the labor costs and the items used for each repair job.

When customers return they pay the total cost of the repair job less the deposit, collect a receipt for their payment, and uplift the repaired computer using this payment receipt.

Identify and writ the relation between entities.