.com/t/RTfVdTUV3H7 a. Do you have any questions or comments

Discussion 2 – Topic 1 1. Import the file named DDL ONLY for Data Modeler.sql into Data Modeler and review resulting relational model. Watch the video first if you are unsure on how to proceed. https://www.screencast.com/t/RTfVdTUV3H7 a. Do you have any questions or comments on the process of reverse engineering a relational database to a relational model? b. Give at least one recommendation to share with your classmates about your experience reverse engineering a relational database. 2. Arrange the Relational Diagram so the relationship lines do not cross each other. Your diagram will look something like this: Discussion 2 – Topic 2 Many of the features of Data Modeler are built into of SQL Developer. Watch a video that demonstrates the data modeling features of SQL Developer: https://youtu.be/hDwJN3KLXWY As you complete the tasks below, place your answers or comments on this document. After you complete all the tasks, write a summary of your answers and comments and post the summary to the discussion. Attach this document containing your answers and comments to your discussion posting. 1. Reverse engineer the STUDENT database from relational database to a relational model using SQL Developer. a. Give at least one recommendation to share with your classmates from your experience using the modeling features of SQL Developer. 2. Now that you can use the Data Modeler using SQL Developer, you will look at more features. You do not need to be connected to the Oracle database to complete the task that follows. Download the sample OE data model (SQL Developer Data Modeler 3.1 – Sample Data Models) from this web page: http://www.oracle.com/technetwork/developer-tools/datamodeler/sample-models-scripts-224531.html. Unzip the file and open the data model in SQL Developer (File\Data Modeler\Open and browse to the OE.dmd file.) If the Data Modeler browser is not open, click View\Data Modeler\Browser. See this video: https://www.screencast.com/t/T6hDCIdL1s a. How many Logical Models do you see? b. How many Multidimensional Models do you see? c. How many Relational Models do you see? i. How many Tables, View and Foreign Keys do you see? ii. How many Schemas are defined? How many Indexes are on the schema? iii. Is there a physical model defined? What types of objects are defined on the physical model? iv. List the Structured Data Types defined for the OE schema. What is a structured data type in Oracle? v. List the Collection Types defined for the OE schema What is a collection data type in Oracle?

Leave a Reply

Your email address will not be published.