Information Systems free essay sample

Courses (Course ID, CourseName) b) For every one of the tables you made, what are the competitor keys? There are Students Table and Courses Table. Understudies Table: Candidate keys incorporate understudy ID, firstName and lastName. Courses Table: They up-and-comer key is the Course ID and courseName. c) For every one of the tables you made, what is the essential key? The essential key of Students Table is Student ID. The essential key of Courses Table is Course ID. d) Explain how the two tables are connected. Which table contains the outside key? What is the outside key? The understudies and their course names make the tables related. The understudy ID relates to the understudies last names and first names and the course ID. Along these lines, this is the essential key. The course ID is the remote key of the Course Table. 2) The Cape Codd Outdoor Sports database has the accompanying tables: RETAIL_ORDER (OrderNumber, StoreNumber, StoreZip, OrderMonth, OrderYear, OrderTotal) ORDER_ITEM (OrderNumber, SKU, Quantity, Price, ExtendedPrice) SKU_DATA (SKU, SKU_Description, Department, Buyer) Stockroom (WarehouseID, WarehouseCity, WarehouseState, Manager, Squarefeet) INVENTORY (WarehouseID, SKU, SKU_Description, QuantityOnHand, QuantityOnOrder) a) There is a defect in the plan of the INVENTORY table. We will compose a custom paper test on Data Systems or on the other hand any comparative point explicitly for you Don't WasteYour Time Recruit WRITER Just 13.90/page Clarify what this plan blemish is. There are 2 essential keys in the stock table, which are the Warehouse ID and the SKU. They are essential key references for connections to different tables. b) For every one of the tables above, what is the essential key? Retail_Order: Order Number Order_Item: Order Number SKU_Data: SKU Warehouse: Warehouse ID Inventory: Warehouse ID and SKU c) Which tables contain outside keys? What are the remote keys? Order_Item table contains a remote key and the outside keys are the SKU quality. 3) We realize that if a table meets certain prerequisites, it is viewed as a connection. Give three instances of tables that are not relations. Clarify why they are not relations. In a segment, passages must be a similar kind or, more than likely the information would not be predictable. Each column must be diverse on the grounds that 2 of a similar kind would not be reliable. A table that has more than one indistinguishable section name would not be a connection since it is confounding to realize where to put information into a table.