Database of CAR MAINTENANCE SHOP
Budget: $30 – $250 USD
Requirements:
• Use Oracle19C/21C or above software to design your database.
• Your database must consist of 4 or more tables with proper relationships. Remember 3NF for your design.
• Represent your database relationships diagrammatically (ER-D)
• Create tables using DDL queries. Add appropriate data rows to each table.
• Design data retrieval queries using various joins, functions, set operators and nested queries.
• Create simple and complex views for the end-users.
• Implement user access control for different objects.
• Create Power point (not more than 12 slides) for final presentation.
Save queries/statements as script(s) with .sql extension, which can be loaded and executed by users.
Create a simple documentation to support your project.
Submit your table structures, records, constraint information, queries, views as well as results.
I DID THE TABLE AND RELATIONSHIPS ON MICROSOFT WORD ALREADY. PLEASE SEE FILE
• Use Oracle19C/21C or above software to design your database.
• Your database must consist of 4 or more tables with proper relationships. Remember 3NF for your design.
• Represent your database relationships diagrammatically (ER-D)
• Create tables using DDL queries. Add appropriate data rows to each table.
• Design data retrieval queries using various joins, functions, set operators and nested queries.
• Create simple and complex views for the end-users.
• Implement user access control for different objects.
• Create Power point (not more than 12 slides) for final presentation.
Save queries/statements as script(s) with .sql extension, which can be loaded and executed by users.
Create a simple documentation to support your project.
Submit your table structures, records, constraint information, queries, views as well as results.
I DID THE TABLE AND RELATIONSHIPS ON MICROSOFT WORD ALREADY. PLEASE SEE FILE