Navigation

    Cyberian
    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Pro Blog
    • Users
    • Groups
    • Unsolved
    • Solved
    Quiz 100% Result
    • CS403 GDB1 Solution and discussion

      Ramish Khan

      Re: CS403 GDB1 Solution and discussion

      Total Marks 5
      Starting Date Monday, February 15, 2021
      Closing Date Tuesday, February 16, 2021
      Status Open
      Question Title GDB Topic
      Question Description
      GDB Topic

      Orchid bank is a private sector bank which has branches in different countries. Orchid bank uses database for the storage of clients’ data because databases can store very large numbers of records efficiently. By using database, we can add, edit or delete data easily. It is more efficient in data searching and data sorting. Database can be used by more than one user to access same data simultaneously.

      As a database designer, which type of database (distributed database & centralized database) you will use in this scenario to ensure data consistency, easy management and easy backup?

      Also, what you think that replication of database suitable in the above given scenario?

      Note: Your GDB answer should not exceed 4 to 5 lines.

      GDB Instructions:

      You need to provide precise and to the point answer, avoid irrelevant details. Copied from the internet or another student will get zero marks. You cannot participate in the discussion after the due date via email. The GDB will open and close on specified date and time. Please note that no grace day or extra time will be given for posting comments on GDB.
      CS403 - Database Management Systems
    • CS403 Assignment 2 Solution and Discussion

      M

      Re: CS403 Assignment 2 Solution and Discussion

      Assignment No. 02

      SEMESTER Spring 2020
      CS403- Database Management System
      Total Marks: 20

      Due Date: 15/06/2020
      Instructions
      Please read the following instructions carefully before solving & submitting assignment:
      It should be clear that your assignment will not get any credit if:
      • The assignment is submitted after due date.
      • The submitted assignment does not open or file corrupt.
      • The assignment is fully or partially copied (from other student or ditto copy from handouts or internet).
      • Student ID is not mentioned in the assignment File or name of file is other than student ID.
      • The assignment is not submitted in .doc or .docx format.
      Uploading instructions
      Your submission must include:

      • Assignment should be in .doc or .docx format.
      • Save your assignment with your ID (e.g. bx020200786.doc).
      • Assignment submission through email is NOT acceptable.
      Objectives
      The objectives of this assignment are:
      • To be able to understand Logical Database Design
      • To be able to perform different relational algebra operations

      Note:
      Your answer must follow the below given specifications.
      • Font style: “Times New Roman”
      • Font color: “Black”
      • Font size: “12”
      • Bold for heading only.
      • Font in Italic is not allowed at all.
      • No formatting or bullets are allowed to use.
      • Your answer should be precise and to the point, avoid irrelevant detail.

      Lectures Covered: This assignment covers Lecture # 14 - 17
      Deadline
      Your assignment must be uploaded/submitted on or before 15/06/2020.

      Question Statement

      Our second assignment is the continuation of our first assignment.
      In the first assignment one question is related to entity relationship data model.
      The entity relationship diagram is given below:

      Now in second assignment, you are required to perform the following tasks:

      Convert the above entity relationship diagram into relational data model. You have to convert all the three important components (entities, attributes and relationships between different entities) of the entity relationship diagram into relational data model. Consider the following tables and perform cross matrix of Shelve, Medicine and Pharmacist
      (Shelve X Medicine X Pharmacist)

      Pharmacist
      Pharm_id Name Address
      Ph001 Ahmad Lahore
      Ph002 Tahir Islamabad
      Ph003 Ather Karachi

      Medicine
      Med_id Name Price Expiry_date
      Md001 Panadol 20 22/2/2022
      Md002 Disprin 20 22/3/2023
      Md003 Brufen 40 22/4/2024

      Shelve
      Shelve_id Number
      Sh001 1
      Sh002 2
      Sh003 3

      Find the degree and cardinality of the following tables (given in 2nd question):
      Table Cardinality Degree
      Pharmacist
      Medicine
      Shelve

      Perform the following operations on the mentioned table and write the corresponding output:
      σ Address == ‘Islamabad’ (Pharmacist)
      ∏ Med_id, Name, Expiry_date (σ Price<= 20 (Medicine))

      Consider the following relations/tables and perform the following binary operations and write the output:

      CreditCard
      card_number expriy_date
      Cardnumber001 23/5/2025
      Cardnumber002 24/6/2025
      Cardnumber003 25/7/2025

      Shelve
      Shelve_id Number
      Sh001 1
      Sh002 2
      Sh003 3

      (Shelve) U (CreditCard) (CreditCard) – (Shelve)
      =====================================Ended=======================================

      For any query about the assignment, contact at [email protected]

      GOOD LUCK

      Spring 2020_CS403_2.doc

      CS403 - Database Management Systems
    • CS403 Assignment 1 Solution and Discussion

      zaasmi

      Re: CS403 Assignment 1 Solution and Discussion

      CS403 - Database Management Systems
    • CS403 Assignment 1 Solution and Discussion

      cyberian

      Re: CS403 Assignment 1 Solution and Discussion

      CS403 - Database Management Systems
    • CS403 GDB1 Solution and discussion

      zaasmi

      GDB Topic:

      The Virtual University has a multi-disciplinary approach and offers extensive degree programs in numerous academic disciplines. Although undergraduate and post graduate degrees are awarded in many disciplines, the most sought and highly popular degrees offered by the University are in the fields of Computer and IT. BS, MS and PhD program offered under the department of CS and IT. Students get enrolled and study the relevant courses in a particular semester. VU manages the information about students, degree programs, student’s achievements, course credentials and many more.

      Let’s suppose, you are the database designer and asked to design the database of above given scenario.

      In order to design the database, you have to choose a data model from the following data models:

      Hierarchical data model
      Network data model
      Relational data model
      As a database designer which data model will you choose for the database designing? Justify your answer in either case with only very solid points.

      Note: Answer should not exceed 200 words.

      GDB Instructions:

      You need to provide precise and to the point answer, avoid irrelevant details.
      Copied from the internet or another student will get zero marks.
      You cannot participate in the discussion after the due date via email.
      The GDB will open and close on specified date and time. Please note that no grace day or extra time will be given for posting comments on GDB.

      CS403 - Database Management Systems
    • CS403 Assignment 2 Solution and Discussion

      zareen

      EDU302 Assignment No. 02
      SEMESTER Spring 2019
      CS403- Database Management System
      Total Marks: 20

      Due Date: 02/12/2019
      Instructions
      Please read the following instructions carefully before solving & submitting assignment:
      It should be clear that your assignment will not get any credit if:
      • The assignment is submitted after due date.
      • The submitted assignment does not open or file corrupt.
      • The assignment is full or partially copied from (other student or ditto copy from handouts or internet).
      • Student ID is not mentioned in the assignment File or name of file is other than student ID.
      • The assignment is not submitted in .doc or .docx format.
      Uploading instructions
      Your submission must include:

      • Assignment should be in .doc or .docx format.
      • Save your assignment with your ID (e.g. bx020200786.doc).
      • Assignment submission through email is NOT acceptable.
      Objectives
      Objectives
      The objective of this assignment is to able the Students:
      • To understand the relational database model
      • To understand the Conversion of ERD into relational data model
      • To understand the Cartesian product of two relations
      • To understand the degree and cardinalities of relations

      Note:
      Your answer must follow the below given specifications.
      • Font style: “Times New Roman”
      • Font color: “Black”
      • Font size: “12”
      • Bold for heading only.
      • Font in Italic is not allowed at all.
      • No formatting or bullets are allowed to use.
      • Your answer should be precise and to the point, avoid irrelevant detail.

      Lectures Covered: This assignment covers Lecture # 10 - 17
      Deadline
      Your assignment must be uploaded/submitted on or before 02/12/2019.

      Question Statement

      Our second assignment is the continuation of the first assignment. In the first assignment an ERD was required for the given scenario, which is given below:
      262aed16-698e-443d-a680-5959bf8d3808-image.png

      You’re required to perform the following tasks:

      Convert the above Entity Relationship Diagram into Relational data model.

      You have to convert all the components of the ERD into Relational Data model.

      Consider the following two tables:

      Order:

      order_id order_status delivery_date btag_no cust_id sman_id
      od001 Completed 10/30/2019 bt001 cust001 sm001
      od002 Completed 10/30/2019 bt002 cust002 sm001
      od003 Completed 10/30/2019 bt003 cust003 sm001

      Bill:
      bill_id cust_id order_id net_amount
      b001 cust001 od001 500
      b002 cust002 od002 550
      b003 cust001 od003 600

      And write the output of the following relational algebra operations:

      • ∏ order_id, cust_id, sman_id (Order)
      • σ net_amount > 500 (Bill)
      • ∏ order_status, delivery_date (σ btag_no= ‘bt002’ (Order))

      Find the degree and cardinality of the relations (Order and Bill) given in the 2nd question.

      ====================================Ended=======================================

      For any query about the assignment, contact at [email protected]

      GOOD LUCK

      CS403 - Database Management Systems
    • CS403 Assignment 1 Solution and Discussion

      zareen
      Assignment No. 01

      SEMESTER Fall 2019
      CS403- Database Management System
      Total Marks: 20

      Due Date: 13/11/2019
      Instructions
      Please read the following instructions carefully before solving & submitting assignment:
      It should be clear that your assignment will not get any credit if:

      • The assignment is submitted after due date.
      • The submitted assignment does not open or file corrupt.
      • The assignment is full or partially copied from (other student or ditto copy from handouts or internet).
      • The assignment is not submitted in .doc or .docx format.
      Uploading instructions
      Your submission must include:

      • Assignment should be in .doc or .docx format.
      • Save your assignment with your ID (e.g. bx020200786.doc).
      • Assignment submission through email is NOT acceptable
      Objective
      The objective of this assignment is
      • To give basic knowledge and understanding of Database.
      • To be able to understand Conceptual Database Design.

      Note:
      Your answer must follow the below given specifications.
      • Font style: “Times New Roman”
      • Font color: “Black”
      • Font size: “12”
      • Bold for heading only.
      • Font in Italic is not allowed at all.
      • No formatting or bullets are allowed to use.
      • Your answer should be precise and to the point, avoid irrelevant detail.

      Lectures Covered: This assignment covers Lecture # 01 - 08
      Deadline
      Your assignment must be uploaded/submitted on or before 13/11/2019.

      Question

      Suppose a water filtration company “ABC” wants to develop a database system for his business flow. This database system will manage its customers, employees, stocks and sales area details. Database system will manage the different sales areas for delivery, defined by the company upon customer request. Customers can place the delivery request at least one day before. The Manager can check the customer order request and generate the bill/voucher accordingly. The salesman will deliver the order to the customer. The customer will pay the dues. After delivery, salesman can also update the order status. Customers can give their feedback about water quality and delivery system. Company will give special discounts and water dispensers to their special customers, and these special facilities depend on the usage of water bottles. Company also wants to keep track of their delivered bottles details.

      • Draw the context level diagram.
      • Identify Entities, their attributes, relationships among entities in above scenario and draw Entity Relationship Diagram (ERD) for it.

      Note: You are required to submit Context level diagram and ERD as your solution only.

      =====================================Ended=======================================

      For any query about the assignment, contact at [email protected]

      GOOD LUCK

      CS403 - Database Management Systems

    CS403 GDB1 Solution and discussion

    CS403 - Database Management Systems
    cs403 fall 2020 gdb 1 solution
    1
    2
    62
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Ramish Khan
      Ramish Khan last edited by

      Re: CS403 GDB1 Solution and discussion

      Total Marks 5
      Starting Date Monday, February 15, 2021
      Closing Date Tuesday, February 16, 2021
      Status Open
      Question Title GDB Topic
      Question Description
      GDB Topic

      Orchid bank is a private sector bank which has branches in different countries. Orchid bank uses database for the storage of clients’ data because databases can store very large numbers of records efficiently. By using database, we can add, edit or delete data easily. It is more efficient in data searching and data sorting. Database can be used by more than one user to access same data simultaneously.

      As a database designer, which type of database (distributed database & centralized database) you will use in this scenario to ensure data consistency, easy management and easy backup?

      Also, what you think that replication of database suitable in the above given scenario?

      Note: Your GDB answer should not exceed 4 to 5 lines.

      GDB Instructions:

      1.  You need to provide precise and to the point answer, avoid irrelevant details.
        
      2.  Copied from the internet or another student will get zero marks.
        
      3.  You cannot participate in the discussion after the due date via email.
        
      4.  The GDB will open and close on specified date and time. Please note that no grace day or extra time will be given for posting comments on GDB.
      Qasim Khan 0 1 Reply Last reply Reply Quote 0
      • Qasim Khan 0
        Qasim Khan 0 @Ramish Khan last edited by

        @zaasmi said in CS403 GDB1 Solution and discussion:

        Orchid bank is a private sector bank which has branches in different countries. Orchid bank uses database for the storage of clients’ data because databases can store very large numbers of records efficiently. By using database, we can add, edit or delete data easily. It is more efficient in data searching and data sorting. Database can be used by more than one user to access same data simultaneously.
        As a database designer, which type of database (distributed database & centralized database) you will use in this scenario to ensure data consistency, easy management and easy backup?

        In my opinion distributed database is better in the given scenario.
        Yes in my option replication of database suitable in the above given scenario.
        We will use relational database, and make the data normalized form. So that we can access, update, delete and execute the records and fetch the required data. The relational database is easy to function the valuable system records.
        The Advantages of Using Distributed Databases for the Banking Industry Banks must be able to access a customer’s information from any branch at a moment’s notice. These information requests can include checking account balances, loan amounts and credit status. A distributed database system separates a business’s data by business function or geographical area.Banks often use distributed database systems, because these systems are configured to carry out specific business tasks in different locations while allowing those locations to communicate freely with one another. These systems offer banks several advantages over non distributed systems.
        Longer Uptime A database management system that requires banks to access financial data stored in a central location can be vulnerable to downtime. The central location may be inaccessible due to communication infrastructure problems, natural disaster or malicious attack. The distributed system lets banks access the information they need at any time, regardless of the uptime status of a central server. A distributed database management system allows banks to reroute their information requests around the inaccessible location to another available site.
        Database replication is the frequent electronic copying of data from a database in on ecomputer or server to a database in another–so that all users share the same level of information. The result is a distributed database in which users can quickly access data relevant to their tasks without interfering with the work of others. Numerous elements contribute to the overall process of creating and managing database replication.

        1 Reply Last reply Reply Quote 0
        • First post
          Last post

        50% Off on Your FEE Join US!

        Quiz 100% Result If you want to know how you can join us and get 50% Discout on your FEE ask Cyberian in Chat Room! Quiz 100% Result Quiz 100% Result
        solution1241 discussion1194 fall 2019813 assignment 1425 assignment 2295 spring 2020265 gdb 1246 assignment 382 crw10174 spring 201955
        | |
        Copyright © 2021 Cyberian Inc. Pakistan | Contributors
        Live Chat